0 votes
1 view
in BI by (17.6k points)

I have created a stacked bar and included 'Row Grand Totals' to the view, further to this have made use of 'Add Reference Line' option and brought Grand Totals for each of stacked bar. But could not bring Grand Totals for the bar which is a Row Grand Total.

In the below image, 'All Business' is the 'Row Grand Totals' to which I need Grand Totals on top of the bar.

enter image description here

Is there a way to achieve this requirement?

1 Answer

0 votes
by (47.2k points)

As you have used reference line method.

  • Make sure first that your Label is value and value is (Sum of Row grand) and line in none.

If you have tried doing this already then 

  • Create a window_sum or LoD calc to calculate the totals. Drag this new calculated field to the Detail shelf. Then add it as a reference line.

Your alternative is to create a dual axis chart.Let me know if you need help in the same.

Welcome to Intellipaat Community. Get your technical queries answered by top developers !