I have a table in which I am trying to use the Rank operator on an expression. The table has 2 Dimensions (Coporation and Manufacturer) in a cyclic group, and 1 expression, which is:
=Sum(Value)
At this stage the table works normally and the Cycle button can be used to cycle between Manufacturer and Coporation. However, I then add the following expression:
=Rank(Sum(Value))
That causes the values in the Corporation field to merge with the values in the Manufacturer field. So if I had Value1, Value2 and Value3 in the Corporation, and Value4, Value5 and Value6 in the Manufacturer field, as soon as I add the second expression, I get Value1, Value2, Value3, Value4, Value5 and Value6 in the Corporation field, and Value4, Value5 and Value6 in the Manufacturer field (as previously).
I want the Rank expression to rank only the values that are in the currently selected field in the Cyclic group, it must not try to rank or show the values in any other field.
