If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I cannot find an answered question regarding this topic.
I have a pivot table where the row measure are an average of a data field. When I click add totals in the it adds up the total records and not the totals of each row. Please see below totals do not add up to the totals of all the other rows.
Days in Status is field that contains numerical data and I want the average calculation to display on the pivot table and the total of those figures to show in the total. I don't know how splitting the days and status into 2 sections will work?
I amended the expression but now it only shows the total and the first column of data titled default. below shows all the other columns which should also be included.
I would like to have something similar, though the entire pivot table become 0, can shield some lights on me?
if(Trans_Date_YYYYMM<=201810, sum( ANP_New_Combine_USD)/1000000,sum( Forecast_ANP_Total)/1000000)
, CHANNEL, [Transaction Month]))