why the partial sum is not showing

[#1]

Subtal is not being showen correctly. I dont have idea whats going wrong. Any one has idea. File is attached.

[#2]

not sure if I understand correctly what you are trying to achieve with aggr, but when you simplify the expression to "Count( DISTINCT PersonID)" it seems to work fine. if you want to then see the zeroes for the products where there are no data points, just untick presentation --> suppress zero-values.

is this what you were looking for?

[#3]

in count actualy I want the number of all doctors in that specialty. like in gen there are 4 doctors and in ENT 5 and 4 should not change even if we select some product.

[#4]

Hi altaf,

PFA, Hope needful has been done.

Regards,

Nirmal.

[#5]

Thanks for Nirmal.. but value itself in count is wrong it should be 4 and 5 but in your chart its showing 16 and 25.

[#6]

PFA...Check now

[#7]

with this data value for all product is 4 and 5 and subtotal should be 9.

[#8]

now check hope values are shown exact.

[#9]

for product p2 values are incorect and secondly product selection is not working.

[#10]

ya for p2 count is 3 only na