I have a requirement to create a crosstab that have several rows from different hierarchy and several columns. One of the requirements is to allow for the user to select from YTD and MTD time periods. I've been able to accomplish this and my values are adjusting as expected.
The next requirement is to have the bottom section of the report to ignore that time period prompt and only have it render for YTD, even if the time period prompt changes to MTD.
It's also worth noting that in my crosstab columns, I have a conditional data item that will pick either the YTD data item or the MTD data item.
Is there anyway I can tell a row from my crosstab to ignore the column data item and only use the YTD data item?