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
With the month dimension, are you using the purple date one or orange dimension one? Do results change if you switch to the other?