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...
can you help me with some data manipulation:
I have CSV file that is structured as file posted in Visualization Challenge #2.
What I want to do:
To more easily analyse data Pivot is used, but data needs to be changed in table where daily sales values are not positioned right...