How to SUM a pivot table in Qlik Sense for graph this values
wanted to sum columns that are added in a pivot table to this day. For example, if today is day 17, add the days of the year-month columns (201803, 201804 ..) and have that total per year-month perior, grouped by day (sum of mounts on a period). To then be able to graph these values.
I need to get the sum of the amounts for the current month until today.
At the first column (201803) I try to sum all that mount from all days of that month (max day from 03 month, march, max day because it already passed that date), so this year_month it's 202001, the sum(mount) of day 1 to this actual day 18, finally to then graph this value.