I want to create a line chart showing sales of top products over time.
To do that, the Product Code must be the pivot field, and the Year must be the Group.
But I can't get Advanced Options for the pivot field, which means I can't select the TOP X products.
Would be great to have the possibility to create this type of chart.