I've got a data model that includes Month, Week ending and some metrics.
I've got another data model that includes the same Month as above and some metrics but isn't provided at week ending.
I'm trying to create one pivot table that has Month/Weekending/Expression A (weekending level), Expression B (Month Level Only)
How do I get expression B to basically show the monthly expression value for all the weeks when they don't have any relationship in the Qlikview model.
Month: October November December
Weekending W1 W2 W3 W4 W5 W6 W7 W8 W9 W10 W11 W12
ExpressionA 23 45 46 34 45 23 67 87 23 45 19 27
ExpressionB 30 30 30 30 40 40 40 40 50 50 50 50