0

I have a set of n product quantities vs dates and I want to display in category groups for the products and the series is the date as a bar graph. I then want to place an aggregated total quantity as a line graph so 1 line graph and n bar graphs on the same chart. The number of products coming in is dynamic.

Is this possible?

Shiv
  • 1,274
  • 1
  • 19
  • 23

1 Answers1

0

To ensure the number of products is dynamic you would need first set up a parameter, integer value, and default it to say maybe "5"

secondly amend your dataset to include the following in your select statement: DENSE_RANK() OVER (ORDER BY "Product") AS "Rank"

thirdly on your graph go to series group properties, filters and input expression "RANK", OPERATOR = "<=" and VALUE = "[@ReportParameter]"

SuperSimmer 44
  • 964
  • 2
  • 7
  • 12