I am trying to add the row grand total as you can see in the below image.
I am displaying only last 6 months data but my grand total shows total of the whole year instead of the displayed 6 months.
Can anyone please tell me how to correct this?
can you please attach twbx
Attaching the sample workbook with this. I have created a sample based on superstore sample data.
Please the the grand totals in sheet1 and sheet2.
Not exactly sure, but hope this helps.
Retrieving data ...