I need your help, i make a straight table with a one dimension's limit..at this table i have added 2 expression: the first have a simple SUM(Amount) the second is a percentage of the total: SUM(Amount)/SUM(Total(Amount)).
But this second expression is wrong! I see that the "SUM(Total(Amount))" gives me a wrong result.
Can you help me about this?
I attached the table.
Messaggio modificato da Giancarlo Saturno
Hi, i have change the file (not it is more simple)
I think dimension limits will cause problem here... you will have to use Rank() function to restrict to the top 17. Would you be able to point out which expressions are we looking at? There seems to be few of them in your chart... not sure which one are you working with....