Pivot table issue

[kkkumar82]

Hi ,

Any ideas on the above in pivot table

[kkkumar82]

Thanks sunny as always, thats a good trick

[kkkumar82]

Apologies all, in a hurry I did that, I will definitely follow it.

[kkkumar82]

thanks for you efforts, but thats not what I require.

[sunny_talwar]

No apologize needed my friend. As long as you make an effort from next time, we are all good

Best,

Sunny

[HirisH_V7]

Hi,

May Be like this,

Using a

Calculated Dimension:

For Product

=aggr(concat(Product,', ' ),[Prod Family])

Expression:

Aggr(Sum(Qty),[Prod Family])

Pivot Table Looks like this,

HTH,

PFA.

Hirish

[#7]

Thank You.