2 of 2 people found this helpful
Here is one idea.
You can specify the G.total column with first()= last().
I believe you keep G.total numbers as full range of date, not only filtered dates.
Thanks very much Shin, that's perfect. Can I apply similar logic to create another column which will aggregate the data for the periods chosen as well?
Not exactly sure about your new request, but logic to specify the cell of total can be used.
If you have conditional formula (including "if statement"), g.total cannot follow that logic as non-aggregated calc.
BTW, if this helped, could you mark my answer as correct to close the thread not from inbox view but from original post.