region wise

[soniasweety]

Hi all,

Ruben Marin

i want to show in pivot table top5 customers by each region

i have 3 regions  --- so in pivot table i want to show  total 15 customers each region 5 customers.

how can i do this?

Thanks

Sony

[soniasweety]

its not working in my case chk the attachment

tresesco

pooja.prabhu.n

jyothish8807

Ruben Marin

[rubenmarin]

Hi sony, as Pooja saids below, if you have different expressions, those differenct expression are the ones showing other customers, try adding the same condition to all expresions. PFA.

You can check supress null values in dimension to remove the null value.

[soniasweety]

sorry  ...

Ruben Marin

if i add customername in  the dimension it is giving me wronfg result..

check the attached.

actual requirment   region should not be in table

dim: accountname

salestage

[jyothish8807]

Hi Sony,

Try this:

=If(Aggr(Rank(Sum(Value)),Region,Account_Name)<7,Sum(Value))

Also refer the attached.

Br,

KC

[soniasweety]

but... i want to see the service amount and hardware amount as a measures also

[jyothish8807 · Accepted solution]

Just copy the same expression and replace you expression for service and hardware

Refer the attachment.

[rubenmarin]

Hi Sony, Jyothish answer above is working, isn't?