5 Replies Latest reply on Oct 25, 2017 4:17 PM by Jonathan Drummey

# Grand Total Does NOT Update With Parameter Top Filter

Hi,

I'm having a similar issue described in
Re: Grand Total Does NOT Update With Top Filter from Calculated Field

However, after hours trying to replicate the steps without success and also reading the article Customizing Grand Totals – Part 2 | Drawing with Numbers , I can't figure it out why the Grand Total doe NOT update.

Could someone help me out?

The goal is to update the Grand Total based on the Parameter Top N.

In the screenshot below; the correct value should be:

Parameter TOP 1 = 413

Parameter TOP 2 = 547

Parameter TOP 3 (ALL) = 629

Attached my worksheet.

Thank you so much in advance for any hint and help.

Best,

T

• ###### 1. Re: Grand Total Does NOT Update With Parameter Top Filter

Hi Thiago,

There's a post that I've never got around to writing on how to do this kind of thing...it's complicated. In order for the table calcs to work we need the right dimensionality for the level of detail of both the detail cells and the grand totals, and that makes the compute using settings that much more difficult.

Here's a view:

The calc is pretty much the same as yours, the dimensions on detail are different and the compute using settings are different, so pay attention to them.

Jonathan

1 of 1 people found this helpful
• ###### 2. Re: Grand Total Does NOT Update With Parameter Top Filter

That was phenomenal Jonathan Drummey ! Thank you

Adding the rank to the column was pure genius. Much easier to spot the needed LOD once you included the rank column. Thank you so much for the help and the explanation.

And even though your piece refers to 'complicated' topics, I couldn't even begin this worksheet without your article. Please don't stop them   I'm a fan!

Best,

T

• ###### 3. Re: Grand Total Does NOT Update With Parameter Top Filter

if I may 'extend' my question, could you explain how I could create a single bar when I have multiple Dimensions due to the LOD calculation?

Attached my attempt, I would need one single bar with the Grand Total per day. Not stacked.

Thank You

• ###### 4. Re: Grand Total Does NOT Update With Parameter Top Filter

Here you go...note that I removed the ...(copy) pills from Detail because they were no longer needed and adjusted the compute using settings of both the nested Rank and Amount TOP N calcs. I also put a duplicate of the table calc pill on Filters and filtered for non-Null values.

Jonathan

1 of 1 people found this helpful
• ###### 5. Re: Grand Total Does NOT Update With Parameter Top Filter

THANK YOU!