Hi, I need to develop a report with a list, donut chart and a bullet chart
1. List Report - For each category (dim) and sub category (dim) showing measures (current month, previous month, Prev to previous month, QTD, YTD)
2. A pie chart for current month measure. If measure>value then in green else if measure>value2 then red else blue
3. A bullet chart to show the measure for selected date ( Radio buttons: previous month, quarter, year)
Fact table grain is at day.