Hi all,
I would like to ask if there is any way to display sums that are duplicated (as compared to the usual de-duplicated sums displayed everywhere), without downloading the data to Excel and summing in there manually?
What I found was
- if I do a calculated metric and select it to be "TOTAL" (instead of Standard) it gives me just de-duplicated sums, so not what I want
- if I do a calculated metric and insert a "COLUMN SUM" function, it actually gives me precisely what I want, BUT it does not work with monthly granularity, i.e. it always gives the column sum of the entire selected period in a report, I would need it to split it by monthly granularity so that it displays just the COLUMN SUM of each month
Any ideas?
Thanks,
Jakub