Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi guys,
i have a pivot table with this hierarchy
category
product
total
i wish a column which shows the number of products for each category. can you redirect me to a thread if my question is a duplicate?
in fact that is what i did but when i found it didnt work i tried using the first dimension. still not good please check the file i just uploaded in the original message up there..thanks
welsa_chy schrieb:
for example
when i expand BLOC1 i have B1-1 and B1-2 and i have total 264 for each.
but this is false because when i collapse BLOC1 i have 264.
If you have the same products in B1-1 and B1-2, count(distinct Product) will result in that.
i used count(product) and its giving me B1-1>>338 and B1-2>>298 when i collapse BLOC1 its 338...
still not good right?
hi,
try count(distinct product),
Hope it helps
yea that's what i tried from the beginning. not working you can check the file i uploaded in the original message on top..
B1-2 seems to me a subset of B1-1 when I look at the table where you link Z3ARGOS_BLOC to PLANIF.
So the numbers seems ok to me.
ohhhh... didn't think of that possibility!!!! thank you so much stefan !!!
i suddenly feel so stupid..LOL
thank you for taking time to reply..i really appreciate