Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone, I am confused about the expression in sort for total of dimension limits. I want to sort the Total column in the following attached file to TOP 1 with this expression below :
but Its not worked. Everybody can help me to give me the best solution, please ?
One option is to create an inline table:
LOAD * Inline [
Dim
1
2
];
And change your dimension to this:
=Pick(Dim, 'TOTAL', MA_DVIQLY)
Expression:
Pick(Dim, Count(TOTAL SLKHANG_MDIEN_TT), Count(SLKHANG_MDIEN_TT))
May be like attached?
One option is to create an inline table:
LOAD * Inline [
Dim
1
2
];
And change your dimension to this:
=Pick(Dim, 'TOTAL', MA_DVIQLY)
Expression:
Pick(Dim, Count(TOTAL SLKHANG_MDIEN_TT), Count(SLKHANG_MDIEN_TT))
Thanks sunindia very much. Your solution is absolute correct