Pl attach a workbook
Hi Ben, right-click on your measure, choose Quick Table Calculation > Percent of Total. Then right-click on your measure again and choose Compute Using > Table Across.
And we have this:
If you also want the actual number on that, you can put another copy on the marks card. Drag Sales (or your measure) to the Text box
Then I usually hit the Show Me tab and choose the table to quickly format things:
Then I re-arrange the columns in the way that makes best sense, and :
Hope this helps,
Hmmm, I tried to re-create a similar scenario. I put multiple levels of dates in, and two dimensions in row. I created a calculation that counts records if they are not null.
With the added dimensions, I chose Compute Using > Pane (across).
It seems to work, the 3 months of each quarter always add up to 100%, and if there are multiple values in the quarter - it gets split into the correct percentages:
I understand why you can't share your data, but without seeing it I don't think I can troubleshoot any further .
I have created an example workbook with a sample of the underlying data with names changed. Let me know if you can think of anything as I cannot at all. Thanks!
I have created sample workbook with underlying data but names change. Let me know if you can figure something out as I am helpless ha.
Hi Ben, oh I get it now. You explained this much earlier in the thread but I couldn't see it without your workbook:
The outcome of your Breadth formula will not only equal 1 for individual dimensions, it will equal 1 at a SubTotal and Total level as well. So it is always calculating Percent of Total as 1/1 for 100%.
I created a calculation to count the number of 1s in each Pane (Company/Transaction/Week) called Pane Total: WINDOW_COUNT([Breadth Count]). You can see it correctly counts the 1s in each Pane.
With that, we can now calculate the Percent of Total with:
[Breadth Count] / WINDOW_COUNT([Breadth Count])
After putting this calc in the view, I had to right-click it, and choose Compute Using > Pane (across)
I hope this helps ,