Sub total in pivot table

[Anonymous]

Hi

In the attached application ‘sales’ is  given a background color by comparing it with Goal1. But the Total which is displayed at the last must be compared against Goal 2 and given color. Qlikview generates the Total (By enabling the partial sum option). So I am not able to change the condition for background color of Total Column.

I tried by removing the partial sum and created a calculated dimension. It didn't work.

Could anyone help on this.

Thanks!

[sunny_talwar]

I am working on it Koushik and will get back once I have a solution for you.

Best,

Sunny

[sunny_talwar]

See if this helps (fixed just the sales number without touching the Target 1 and Target 2, if required for them, the same logic will follow) PFA

Best,

Sunny

[Anonymous]

Thanks for the help once again.

Now the Continent total is shown even if a city is selected.

but there is a small prob,

The total highlighted is shown as '-'(Null).

Is there a way to see the total ? I expect it show the total of each city(Total of months selected)

[Anonymous]

Hi Sunny

One more problem.

When i dont select any city or continent everything looks fine

But when a city say Tokyo is selected the look is like,

I expect tokyo alone to be displayed along with the city and continent level total.

Other citys like the one marked in blue which shows '-' should not be displayed.

Could you please help me on this.

Thanks!

[sunny_talwar]

Hey Koushik, can you send me all your requirement in an email? You don't need to post images, just let me know what selections need what results. I am going to follow you so that you can send me private message and I will give you my email id.

Best,

Sunny