This content has been marked as final. Show 9 replies
I'm using the following formula:
Avg(Aggr(Count(Distinct CaseNumber), Warehouse,Year,Date))
The pivot table comes out like this:
When I try to validate the totals line in Excel, I am getting different numbers:
I am currently hiding Nulls in this table for Warehouse. PFWarehouse is a calculated master dimension:
If I do not exclude Nulls from the pivot table I get the following data:
Qlik is adjusting the totals, so I don't think the Null warehouse is throwing this off. Perhaps my formula needs some fine tuning?