Show numbers as Percentage in Pivot Table

[vksthkkr]

I have a pivot table that shows order numbers like this.

The expression is Sum(Order_Value)

I want to create another table that shows weekly numbers as % of total for each month. the representation (in Excel) looks like shown below

Need help with the expression that needs to be used to make this work

[qlikviewwizard]

Hi,

Can you attach the sample data?

[olivierrobin]

hello

try something like

Sum(Order_Value)/Sum(total <month> Order_Value)

[sushil353]

Hi,

You need to use aggr function to get the percentage.

something like:  sum(Order_Value) / aggr(Total Sum(Order_Value),Month)

HTH

Sushil

[dapostolopoylos · Accepted solution]

Check out the attached app.

[qlikviewwizard]

What is the logic to show percentage in the second table?

It is not clear how you calculated? Can you explain how you got 16% for 2017-Apr for W-2?

[dapostolopoylos]

It's a pretty straight forward app.

It calculates the share of every week versus the total revenue by month...

It was what vikash asked for.

[qlikviewwizard]

2017-Week1 :16+17+13=46 But your value is 45. How?

[dapostolopoylos]

Arjun,

being a level 9 forum member means that you can easily understand the calculations on the second table of my app and i find it weird that you want me to explain to you this calculation :

Sum(Revenue)/Sum(TOTAL<Year,Month>Revenue)

[vksthkkr]

This is exactly what I was looking for.

Thanks a bunch for the example document!