MostCommon function in a PIVOT table. Count of MostCommon Value.

Hi there

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.

Kind regards

(1) Answer