Hi ,
We have stacked bar chart for year and quarter so i can get the total for each quarter and display them, but how to show the total for entire year and show that total in a tooltip?
As per the image,how to show the totals for 2019 ,2020 entire year?
You could create a formula to be the sum across each year. It can leverage the second parameter in the SUM method where you put the year/date hierarchy in so that it gives you the sum for that measure across each year. Like this:
SUM($Measure$,$Year$)
Then you can add that new formula measure as the data point label in the Visualization tab of the data analysis panel
