I need to create a chart where I need to provide detail data along with total and at the last grant total as well. Please suggest
Select the Chart Node Member in the Categories section and go to Summarize -> Total in your Report Studio toolbar. It should add the total next to your category.
Alternatively, you can create your data item total([xyz]) and drag it to the right of your chart node member.
Thanks a lot. it works perfectly..
With this requirement some modification took place, where in the graph top5 values need to show beside grand total. means if 10 values are there in the graph only top 5 and grand total of 10 need to show. Please suggest
then, dont use summarize, create a Grand total item instead and drag it in your chart.