1 of 1 people found this helpful
The reason that the parameters don't seem to be taken into account when using the total function is because the 1920's in top N% is using the index function. This is essentially only hiding the values that are not shown in the view (they are not actually being filtered out). If you place the column grand totals, you will notice that the total does not change either when moving the parameter slider. Unfortunately for your use case, I don't think that it's possible to get the value in your title, unless it is hard coded. Suggesting the summary card and/or its contents may be a good one for the Ideas in the Community!
Thanks Tracy - at least I can stop beating my head against that wall! I'll make the suggestion.
I still need to figure out how to provide those summary counts in the dashboard so any ideas would be much appreciated!
I sincerely hope that a summary card for the dashboard can be provided, because that would be so much easier and save quite a headache, but I think I actually have something working. Do double check though because I've gone cross-eyed.
I'm calculating max of running totals of what you can see and then adding them as discrete hidden columns. Then I can add them to the summary. Amending the parameter means what you can see is changed, so the calculations follow what you have changed as well.
I hope this helps!
My Try.zip 549.4 KB
All my managers are asking for the quick summary to be displayed for quarterly reviews for each business segment.
This feature is absolutely sought after.