Skip to Content
0
Jun 01, 2015 at 03:22 PM

sum issue in cross table

250 Views

hi all,

We have city, product diminsion variables in report. Both are displaying blank value (I created these variable to display specific values only)..

Below is the sample data.

P1 P2 P3 C1 3 5 2 8 C2 8 2 6 10 C3 2 4 8 12 9 7 5 11 Total 13 11 16 Total in Country 22 18 21

I need to exclude blank values for both variables, so I created filters on block (=Not Null). Also I need to display data for one country, so i created report filter for one country.

But I am not getting correct values for 'Total in country' row as mentioned in above table, could you please help me on this....

I tried with NoFilter() InReport forall()...but no luck...

Thank you,

Ranjith