Forum Discussion
Table with Ultime N
Dear All
I have a table with data with following information
Aging and FW (fiscal week)
Considering that I have about 100 value of Aging for each FW.
I need to view only the first 5 Top aging of the last FW (in term of last time)
I found that we can use only one Prime Filter instead of in my case I need to use two prime filter for the same table.
Do you know if we can have an alternative solution?
Thanks
Regards
Hi riccardotesti76 - If you prefer to pre-calculate the filtered data, you can create a calculated table
Top 5 Aging Latest FW =
TOPN(
5,
FILTER(
'YourTable',
'YourTable'[FW] = MAX('YourTable'[FW])
),
'YourTable'[Aging],
DESC
)you can use this table in your visualization, Hope this works
2 Replies
Hi riccardotesti76 - If you prefer to pre-calculate the filtered data, you can create a calculated table
Top 5 Aging Latest FW =
TOPN(
5,
FILTER(
'YourTable',
'YourTable'[FW] = MAX('YourTable'[FW])
),
'YourTable'[Aging],
DESC
)you can use this table in your visualization, Hope this works
Fantastic!!! You suggested a formula that I can customized for several issue!!!
Thanks
