Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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])
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])
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
thank u so much