Currently, the tooltip for each line shows a percentage of total for each day. I need help creating a level of detail expression such that when I filter out one or more of the lines, the percentage is calculated as though all of the lines are still in the view.
Any tips, suggestions, or other assistance would be greatly appreciated.
Thanks
Jun 13, 2016 9:03 AM
hi Patrick,
Hopefully this will do the trick...
I've added a new %age calculation
[% of records LoD]
sum([Number of Records])/SUM({FIXED [Calldate]: SUM([Number of Records])})
As the LoD is immune to regular dimension filtering, it means that regardless of the filter it *should* still be correct. I'e added it into the tooltip so you can see what it's doing.
Let me know if that isn't what you were after, or doesn't make sense
Lol, thanks. I came up with the same solution right now while out on a walk. Very much appreciated.
