Use WINDOW_SUM(SUM[Revenue]) as your calculation and then set the Compute using for that pill to child company, so the data will be partitioned based on the parent company. If you have additional dimensions in your view, you will likely need to use the Advanced... Compute using to get the calculations to work properly.
An example using Product and the Product's Sub-category is attached.
Thank you for your help!
How do I access the advanced... compute option you mentioned?
1 of 1 people found this helpful
Click on the pill, then click Edit table calculation, then in the Compute using drop-down choose Advanced...
If you're not familiar with table calculations, I suggest you check out the following links:
Beat me to it Jonathan (I was looking at this this morning) - thanks!
Geoff - to get to the advanced compute, you can right mouse click on the Sub-Category Sales (in Jonathan's example) on the Measure Values shelf and select "Edit Table Calculation..."
This will open up the Table Calculation dialog. In the lower left of this dialog, click on the "Edit Formula..." and it will open up the calculated field he set up called "WINDOW_SUM(SUM([Sales]))"
See attached screenshot.
Also - there's a great training video online that discusses advanced table calculations here:
Table Calc - Edit Formula.PNG 68.4 KB