Announcements
cancel
Showing results for
Did you mean:
Contributor III

## Show numbers as Percentage in Pivot Table

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

1 Solution

Accepted Solutions
Creator III

Check out the attached app.

Father/Husband/BI Developer
9 Replies
Master II

Hi,

Can you attach the sample data?

Specialist III

hello

try something like

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

Master II

Hi,

You need to use aggr function to get the percentage.

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

HTH

Sushil

Creator III

Check out the attached app.

Father/Husband/BI Developer
Master II

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?

Creator III

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.

Father/Husband/BI Developer
Master II

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

Creator III

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)

Father/Husband/BI Developer
Contributor III
Author

This is exactly what I was looking for.

Thanks a bunch for the example document!

Community Browser