Issue with expression:

[#1]

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

[sunny_talwar]

Would you be able to share a qvw sample to play around with?

[MindaugasBacius]

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:

The Aggregation Scope

What does the TOTAL qualifier do?

[#4]

Sure Sunny, adding the sample in a new thread.

[#5]

Hi Mindaugas, Its not that simple.

[settu_periasamy · Accepted solution]

Hi Pavan,

Hope, you are using pivot table. Then try this expression

Below(sum(Sales))/Before(sum(Sales))

Format should be, Fixed 2, percentage.