I facing an issue to know the value which has max count, let me explain you by example.
|Month||max( aggr( count(Cost),Month,Cost))||Max Cost Value|
I can able to achieve the max count but I am facing an Issue finding the max cost value. Can you please let me know how can I achive this? Thank in advance.
Solved! Go to Solution.
May be this?
If you can accepted that adding some scripts in back-end, then I found a method, but I think it's not good, I'm trying to find another way.
LOAD * INLINE [
Count(Cost) as num
Group by Month,Cost;
LOAD Month,Cost,max(num) as num Resident T2 Group By Month,Cost;
DROP Table T2;
The expression : FirstSortedValue(distinct Cost,-num,1)
Thanks for your reply uacg0009As you said I need in Pivot table script it self. Adding another table will become performance Issue in our case.
Actually you can see my data model, I didn't add table, I just add one column finally.
But It will takes some times to make this column, so if your data is too large, it will affect your loading time I think.
If you can't accept this method, maybe I need to try to use another front-end way to make it.
Yes Aiolos, Table has some millions of data adding another field will cause performance. If we don't have any front end way then I can go with backend script.