1 Reply Latest reply on Mar 20, 2019 11:58 AM by Gigazelle

    Duplicated Sums display in Adobe

    jakubl3000 Level 1

      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