Please look at attahced file. I need to have total not affected by any filter. So despite that I will filter only few monts of sale - as a total I need to see whole year (as a last bar on chart). I was trying to use FIXED LOD, but it is not working or I do not know how to do it :(
4 respostas
good morning - see the blue tab - also see https://jimdehner.com/2023/02/28/grand-total-and-sub-total-use-cases/ or if yoiu prefer video https://youtu.be/5TZK6nbzbsE it will explain how to use a custom grand total
