6 Replies Latest reply on Feb 23, 2012 2:59 AM by paul.kretacz

# Cannot turn on Grand Totals for discrete measures - specific example

Hi,

I browsed forum for the solutions to the cannot turn on Grand Totals for discrete measures problem but did not find any solutions which would solve my problem.

I have a calculated field which segregates data into two columns and would like to have Grand Total. The problem is that I have another discrete calculated field in place which makes it impossible to add the Grand Total column.

Is there any way to overcome this problem?

Cheers

Paul

• ###### 1. Re: Cannot turn on Grand Totals for discrete measures - specific example

The positioning isn't perfect, but yes, you can add a calc that gives you that. You could also use a dashboard to bring it all together

• ###### 2. Re: Cannot turn on Grand Totals for discrete measures - specific example

Hi Paul,

I have reattached your workbook with two different options. The first, is to simply make the diff calculation continuous. The other is to create your view using a couple other calculated fields. Hope this helps!

-Tracy

1 of 1 people found this helpful
• ###### 3. Re: Cannot turn on Grand Totals for discrete measures - specific example

Nice and simple Tracy - like it

• ###### 4. Re: Cannot turn on Grand Totals for discrete measures - specific example

I use the diff calculation to sort the data, so the last solution is not helping (unless you can sort by the continuous field - which would be really cool!). Eventually the diff calculation is supposed to be hidden - sorry that I wasn't clear.

I also need to have the total on the right side, so I can't use the first solution.

Thanks again, any more ideas appreciated.

• ###### 5. Re: Cannot turn on Grand Totals for discrete measures - specific example

What is diff doing compared to a simple sum() minus sum ()

• ###### 6. Re: Cannot turn on Grand Totals for discrete measures - specific example

Hi,

In reality I use many calculated fields and the one that I currently have to sort by is:

window_avg([Sales],first(),first())-window_avg([Sales],first()+1,first()+last()))

Thanks

Paul