Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am using a pivot table with some dimensions and measures.
Dimension: Product Family, Customer etc.
Measure: its just calculation Sum (Revenue)
for Customer i used a expression : Dual(Customer, Aggr(Sum(Revenue),ProductFamily,Customer))
It should show me FORD, GM etc. as shown in the pivot table.
But it is not showing this.
Can someone please help ??
I think there is an issue with calculated dimension and filter pane collapsed. If you extend the size of the filter, you will see the values, but when it is collapsed, the drop down doesn't show values.
Hi Sunny,
Actually the calculated Dimension works perfectly. In the pivot table i could see that the measure and dimesions are showing up.
Its just that when i go to select the Dimension as shown on the top left hand side of the pivot table.
I do not see any value.
As you could see in the image attached earlier the customers are Ford and GM. it should show up.
Extending the size of filter doesnot helps here.
That's what I sort of mean. Its a bug and not sure if they have resolved this yet
Oh
Sunny can you take a look at this thread : Sorting within a dimension in a pivot table.
Actually i was trying to solve this piece when the error mentioned in this post appeared.
I was suggested a solution here and it works, but the limitation was set up in the Dimension.
If i go ahead with this solution, my dimension filter would not work.
Can you suggest any alternative solution ??