Pivot Table

[Anonymous]

Hi

Following is the screen shot of my application.

It shows the Sales of various city across continents.

There are three dimensions involved here. Continent ,City, Month.

When i select a city say Tokyo i expect the below highlighted Row to display entire Asia's Total.

Also i expect the World total(Sum of three continents) displayed at the last row (Highlighted in the below image)

So using dimensionality and set analysis the implementation is done.

But by problem is when i select Tokyo,

I expect Tokyo's total along with Asia's total(Sum of Tokyo+Sum of Delhi) and

World total(Sum of Asia + Sum of Aus + Sum of Europe) to be shown.

Please follow the below image to understand what i expect.

But the other city's values are also displayed as '-' like,

Could any one help me on this please.

Have attached my sample application.

Please let me know if further information is required on this.

Thanks!

[Anonymous]

I am not getting it

is it because of version?

is there an alternate way where we can achieve the same in SR3?

Could you please help me on this?

[jagan]

Not Sure.  Did you selected supress Null values and Supress zero values option in presentation tab.

Regards,

Jagan.

[#4]

This is your original application screenshot. with our dimensionality formulas .

Your original applications works alright .

Version 11 SR9

[Anonymous]

Thanks for the answer

[Anonymous]

Hi Jagan Mohan

Thanks a lot for your help.

I am using SR6 now and it is working as expected.

Thanks