Mixing Standard and Synthetic Dimensions in the same Table
I had the following question earlier today:
To be clear: Let's say I need to show the total sales of last year in the first column (named "Last Year Sales"), total sales of actual year in second column (named "This Year Sales"), and the following columns come from the "Month/Year" field and show the sales in each month of the selected values in "Month/Year" field.
The first 2 columns will always be there, but the Month/Year columns depend on the field selection. I thought about using the field "Month/Year" inside the ValueList() function, but I couldn't make it work properly.