I would like to create a waterfall chart by time period which has a grand total column as full bar. Lets say i expend time period to show quarters it will have multiple years in axis broken down by quarter. Is it possible to create cumulative grand total in each of the years. For example for 2010 there is one grand total which is a full bar but next year is incomplete bar as it takes the reference from first grand total. i need 2011 grand total to show 2010 + 2011.. is it possible? screenshot is shown below.
Thank you so much!!
when we add Grand total directly then it will show like your view.
Try create new variable or union all to work with query and try.