MostCommon function in a PIVOT table. Count of MostCommon Value.
I have a question regarding my Spotfire model.
In the Pivottable which we have formed, we have agents, we have an average column in the Pivot table for the sales quantity and a 'MostCommon' sales quantity value per Agent.
Now, as another expression, I want to add a column counting the MostCommon value per Agent? Can anyone give some guidance?
So finally we will display the agent, the average sales per agent, the most common sales quantity, then a count of how many times the most common sales value occurs per agent.