I have a pivot table which as Monthname(date), Date as dimension, Sum(Amount) as expression and it's subtotaling correctly for each Monthname(), but I can't seem to get in an expression the total for each Monthname(Date). Any pointers?
Total qualifier works with field names, not with expressions. But I would expect that sum(total < Date > Amount) return what you need. Doesn't it? If not, it makes sense to create a separate field for month.
