Hi,
I'd like to be able to create custom subtotals for say Total Revenue based on other values.
I'm using the idea from the video linked below to do this using a SWITCH function.
The irony is the normal values pull through okay, it's the [Total Rev] value that doesn't, which is strange as the...