Forum Discussion
Exception for sub-total
IF , not very clear
But it would be like
New B = Sum(Table[B])- Sum(Table[M])
% = Divide([New B], Sum(Table[B])) , what is denominator for % ?
Hi,
Thanks for the answer. Sorry for being unclear. Based on the data, I want to have the following table:
| A | B | C | PP | RR | ||
| 35353 | 2M | 236 | 23 | 4 | 9% | 5% |
| 35353 | 3M | 233 | 21 | 2 | 6% | 4% |
| 35353 | 6M | 251 | 33 | 4 | 9% | 4% |
| 35353 | 7M | 263 | 43 | 2 | 6% | 3% |
| 34 | 3% | |||||
| Total(N) | 983 | 86 | 12 | 26% | 16% | |
| Total(%) | 8.7% | 1.2% |
8.7% is 86/983 (SUM(B)-SUM(M))/SUM(A) However, I don't know how to show it in a table or in a similar format that I provided. This should be series for all XX values. Actually a matrix or a table is fine as well. Also as you see in Total(N), some of the totals are exclusion of SUM(M) and some of them don't include. When I have a table or matrix, it gives total with the same logic for all columns, I belive. At least, I don't know.
All the best
IF , I doubt you can create a table which shows %total below total. The best you can do is change total by using is filtered or is in scope or has one value.
https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/