Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Table1
I have two dimensions, Vintage and DLQT_STAT: And have an expression as Sum(Sales).
Now I have to create a new table.
Unable to explain the logic, I have created a excel with formula.
Table2 has same dimensions just need to change the expression. Any idea how I can achieve it?
Thanks,
Pavan
Hi Pavan,
Hope, you are using pivot table. Then try this expression
Below(sum(Sales))/Before(sum(Sales))
Format should be, Fixed 2, percentage.
Would you be able to share a qvw sample to play around with?
Try using this:
Sum(Sales) / Sum(TOTAL Sales)
Also do not forget in Presentation tab to change numeric format:
Read more about TOTAL in expression and it's use in here:
Sure Sunny, adding the sample in a new thread.
Hi Mindaugas, Its not that simple.
Hi Pavan,
Hope, you are using pivot table. Then try this expression
Below(sum(Sales))/Before(sum(Sales))
Format should be, Fixed 2, percentage.