Hi,
I currently have a workbook where I am running a % of total calc with a few filters applied. The problem is that whenever I adjust the filters the grand total always recalcs to 100% - I'd like to see the new grand total percentage ie - what % this filtered selection makes up of the whole.
Specifically, I want to be able to filter counties out. So in my case the numerator would be counties selected and denominator would be whatever combo of data item and Ag district I've selected. ex - Dryland and Southern High plains with all counties would be 100% but then as I remove counties I want that 100% to drop. I don't want ALL data item and ALL ag districts to be the 100%, I need the 100% to be based on the specific combo of the two and then adding/removing counties adds/subtracts from the grand total. Any help is greatly appreciated.
Hi @William Freihofner, does the screenshot below look like what you are looking for?
I just changed the calc. to LOD expression and also changed some filters to context filters.
Workbook attached for ref. I hope this helps.
