Help with a line chart?

[Anonymous]

Hi,

I am trying to create a line chart that displays by month the top 10 of more requested items. The proble that I am having is that I want to display the 100% by month (besides that the top 10 is not the 100%).

If I use a count or sum and in the dimension limits set the 10 as max numbers will partially work. But I want to have the % of each item of the total of items for each months.

Is there a way to do this or I mixed all and confuse everyone?

Thanks,

[swuehl · Accepted solution]

That's probably because you are using TOTAL qualifier without the field list:

Count({$<Code= {"=Date#(YRMON, 'YYYY-MM') > MonthStart(Today(), -12)
AND
Date#(YRMON, 'YYYY-MM') <= MonthEND(Today(), -1) "}>} DISTINCT Code)/

Count(Total<MonthDimensionField> {$<Code= {"=Date#(YRMON, 'YYYY-MM') > MonthStart(Today(), -12)
AND
Date#(YRMON, 'YYYY-MM') <= MonthEND(Today(), -1) "}>} DISTINCT Code)