Summary based on the straight table data

[ashishbhuyekar]

Hi All,

I am having below data in straight table where Status is dynamically generated based on the expression. Now i want to show summary from the table data. How can show that?

ID	Status	Route	Count
1	Available	6	6
2	Available	6	6
3	Change Required	12	12
4	New Requirement	18	15

Summary that i want to show -

Available	2
Change Required	1
New Requirement	1

[sunny_talwar]

What are the expressions from your details chart?

[ashishbhuyekar]

Dimension

ID

Expressions

Max(Route)

FirstSortedValue(Status, -Route)

[sunny_talwar · Accepted solution]

May be try this

Dimension

Aggr(FirstSortedValue(Status, -Route), ID)

Expression

Count(DISTINCT ID)

[ashishbhuyekar]

Thanks Sunny,it worked!!!

[ashishbhuyekar]

Hi Sunny,

Can you please help me on below post?

Show the category based on variable

Thanks in advance.

Ashish