Hey All,
Recently began working on Cog 10, and it seems they have changed the way summaries work on Crosstab. I have an issue below that I can't figure out...dunno if it's due to loss of memory on my part (not having worked on crosstabs for a while) or it simply can't be done but I faintly recall being able to do this on Cog 8. Sadly, the cog 8 sandbox has been taken down so I can't test it out.
Anyway, it's a fairly simple crosstab. Rows have Month Year (very innovatively done by concatenating year and month fields from the DB ;)) and another field nested next to it. Columns have a few measures (all calculated). I need a YTD summary (fancy way of saying summation of the rows) for the nested part of the rows...let me try to illustrate:
............................. Column1...........Column2...Column3
Jan 2013
.............. A1 100 200 300
............... A2 50 60 70
................A3 10 20 30
Feb 2013
.............. A1 80 90 100
.............. A2
...
YTD
...............A1 300 400 500
...............A2 700 800 900\
and so on
After adding a summary and dropping the query item which contains A1, A2 etc, next to the summary line, I get an error that non measures can't be included in this line
Dropping the query item just in front of the summary line brings forth a complaint of mismatched levels
Any help will be appreciated.
Thanks
I can probably get this done by having another crosstab on the page with just the levels (A1, A2 etc.) on the rows, measures on the columns and restricting the query to the year picked by the users but am trying to avoid this second crosstab