I need to shov top 20 customers plus rest in a table.
I use Pivot with TOP 10 filter to TOP 20 ITEMS. I need to add field with REST values after 20th customer to have full month data.
Can I do it with flters and caltculated filds?
I am now creating two tables and joining them for final report.
Thanks for ideas,
Luka
I use Pivot with TOP 10 filter to TOP 20 ITEMS. I need to add field with REST values after 20th customer to have full month data.
Can I do it with flters and caltculated filds?
I am now creating two tables and joining them for final report.
Thanks for ideas,
Luka