Hi,
This is going to be a bit vague, I had a matrix containing Month and date from 'calendar table' and when I dropped the total sales measure into value
it was flited down to one row showing the grand total. I tried to replicate the situation but haven't been able to do so. I'd copied the formulas into notepad,
so definitely no difference, The only thing I created the Calendar table using 'calendar' rather than calendarauto as I had previously, but can't think this made a difference. Any ideas.
Richard
This is going to be a bit vague, I had a matrix containing Month and date from 'calendar table' and when I dropped the total sales measure into value
it was flited down to one row showing the grand total. I tried to replicate the situation but haven't been able to do so. I'd copied the formulas into notepad,
so definitely no difference, The only thing I created the Calendar table using 'calendar' rather than calendarauto as I had previously, but can't think this made a difference. Any ideas.
Richard