Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a chart simple table where percentage and names as the following example:
% name
97% v-shoes
111% v-tshirt
and go on...
The percentage is about the sales comparison with the last month, so 97% indicates that so far in the month the company didn't reach the last month sell.
Ok.. till now is implemented.
What i need now is to add at the bottom of this chart a new line where this line is the percentage of all sells from previous month to the current month
like
the total sell from previous month is 100000000 and actual month is 9999999999 sou i get the percentage as previous_month/actual_month
the formula is alright and i can see it in a text object, but what i need is to insert this value at the end of the pivot table as a new line..
has anyone experienced something similar?
thanks in advance...
Have you had a look at Properties - Presentation - Dimension and Expressions - Show Partial Sums?
HTH
Peter