Grand total based on blocks ..??

[Former Member]

Hi all

My req. is like, I have 3 blocks, each block I have sum and each block data has on different filters. Now I want put Grand total by summing of all blocks sum. I tried to create variable and putting all filter conditions (3 blocks conditions) in where clause. But it returns last block sum value only. Is there a way to achieve this grand total?

Regards

swetha

[former_member200478 · Accepted solution]

Hi swetha,

Try this :-

=Nofilter((Sum([Measure value]) In Report))

It will give you the sum of all the blocks irrespective of any filters.

Regards,

Tanb Gupta

[Former Member · Accepted solution]

Hi

It was solved. I used ForAll function.

Thanks to every one here.

swetha

[Former Member · Accepted solution]

Good Posting Swetha.!

Regards,

Vamsidhar.K

[Former Member · Accepted solution]

sorry. that solution for other post. But for this, I have created separate table with one row, created sum variables as per filters. it resolves my problem. Thanks to everyone here.

[Former Member · Accepted solution]

Anyways Good work. Keep posting and update the changes.

Thank you,

Vamsidhar.K

[former_member210032]

Hi Swetha,

In your report you are using break or section...?

Regards

Mustafa

[former_member203850]

Lets consider 3 objects in report:

Year                     Sales Revenue                          Month

Apply Break on the 'Year' Object

To calculate Sum of Sales Revenue use this formulae :

=Sum([Sales revenue] ForEach([Year]))In Report

Hope it helps

Regards,

Pranay

[Former Member]

report already in form of blocks. I cant Break it. it will spoil report output format which client is expecting. Is there any other way Pranay ..??

[former_member203850]

Hi Swetha,

Lets consider two objects in report.

1. Year  (Available values : 2004,2005,2006)

2. Sales Revenue

Created three different variables in report for year.

2004, 2005 , 2006

And placed in different blocks.

And then applied the Total sum of Sales revenue in the third block.Please  find attached snapshot for the same.

Let me know if you have any issues.

Regards,

Pranay