calculated dimension

[#1]

Hi Experts,

i have a pivot table like below

wherever a particular product number has two or more customer details in it, then i want to display as Customer 1, Customer 2, Customer 3, & so on...

Required output:

is it possible?

if so, can someone please help me with the calculations?

[sunny_talwar · Accepted solution]

May be like this in your calculated dimension for [Customer Details]

Aggr(If(Count(TOTAL <Area, [Product No]>[Customer Details]) > 1, 'Customer ' & RowNo(), [Customer Details]), Area, [Product No], [Customer Details])

[marcus_sommer]

If you are handling with a large dataset it might be better to create this as new field within the script than such calculated dimensions could be slow down the app-performance.

- Marcus

[#4]

thank u so much