-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
% of total
-
J
Using % of Parent Row Value in a Calculated Field
I am looking to create a calculated field in my pivot table using the value generated from the 'percent of parent row'. I'd like to multiply it by another column but am finding that this might not be possible. Is there a way to do this? Or if not, is there an alternative? The pivot table has 4...- joeymonts18
- Thread
- % of total calculated field parent pivot table pivot table % formatting
- Replies: 0
- Forum: Excel Questions
-
B
DAX Formula- % of Total
Hello I'm trying to write a PowerPivot DAX formula to get the percentage of total based on a subcategory. Ideally I'd like to click on a slicer and have to formula automatically calculate the % of total. It seems like an easy formula, however I've not been able to get it to work. Below is the...- bravo1563
- Thread
- % of total dax percent of total powerpivot 2016
- Replies: 7
- Forum: Power Tools
-
M
% of total by level with drill-down in Power View.
Hello guys, I have a table that contains how much a client paid for an invoyce ([Valor NF]) and which department received that money. However, my company divides a department in 3 hieararchical levels, which are then represented in the workbook by 3 fields named Dept. Lvl. 1, 2 & 3. Here is my...- mozartiano
- Thread
- % of total hierarchy powerview revenue sum
- Replies: 3
- Forum: Power Tools
