Regarding doubt in calculation of Total distinct code

[qliksus]

Hi,

Please open the attached file. Then open the excel file then you can see 2 dates are there. For 03/11/2009 there total 6 distinct outlets are available. My requirement is if i select brand F , output is

(Count of Distinct outlet where F is present on that date / Total count of distinct oulet on that date)

= for foster distinct outlet is 4/ total outlet on that date is 6

=4/6

=66.67%

Same thing for every brand.

I am getting output when i am taking Date as dimension in My pivot chart but i don't want to take. In QVW file you can see in the AVAILABILITY-1 CHART i am taking Date as dimension , so that output is coming correct i.e 66.67%. But in the AVAILABILITY-2 CHART i am not taking date as dimension , so that for Brand F output is coming 50% which is wrong.

Can anyone helpme to solve this problem??????

[#2]

Hi,

do you realy need a pivot table?

If not, use a straight table and hide the column date (presentation tab).

If you add the field "pack" than you will come out by 50% for brand f.

Hope it helps!

Rainer

[qliksus]

Hi Rainer,

Thanks for reply. Sorry for late reply due to unavailability reason. But i want only in pivot chart because i want to add pack code as a dimension in chart. So the required format is intialy chart will show the Brand wise Availability then if the expand it it will show pack wise.