No matching

[soniasweety]

Hi All

Anil Samineni

Jyothish KC

franky_h79

im calcualting the top5 customers by region wisse in one table

other table i have detailed info

but if i select region i can t see the matching numbers for top5

how to fix it?

and one more -   in  Production  top5 table is taking lower value

means i have ID column so for perticular account two id;s are there  in that lowest values is showing in top5 table.  how to show the max value only in this case?

[manoj217]

You are saying your tables is not matching the sum of values right?

may i knw why r u using expression for top 5 directly you can use dimension limits it will show s on ly top5 customers

[jyothish8807]

Hi Sony,

Replace your total expression by this:

=If(Aggr(Rank(Sum(Value)),Region,Account_Name)<7,SUM({<SERVICE_TYPE={'Hardware','Service'}>}Value))

Br,

KC

[soniasweety]

thanks  i will check and update in 5min

[manoj217]

[soniasweety]

jyothish8807

No stil i can see same issue    it is showing 5 value as 0  but i have max value for that is  80  its top3 values but im getting 0

its taking  low values  instead of max values in the top5 table.  how to get only max value

[soniasweety]

can you atatch the application?

[soniasweety]

manoj217

[manoj217]

=IF(Aggr(Rank(SUM(Value),4),Region,Account_Name)<=5,SUM({<SERVICE_TYPE={'Service'}>}Value))

[jyothish8807]

Hi Sony,

What are the dimensions you are using. Can share the screenshot of the complete table ?

Br,

KC