Hello, I built a pixel perfect template in QS Cloud. I'm using a Cross Tab, defined as following:
* Rows: dimension "Type" (e.g. type is Sale, Buy, ...)
* Columns: dimension Month
* Two values: Amount and Amount YTD (which are two measures)
I put the values as rows, so the structure is as follws:
January February ....
Sale Measure 100 200
Sale YTD 100 300
Buy Measure 20 30
Buy YTD 20 50
I would hide the row "Buy YTD". I see there is a "Row Visible" property. I tried to set it with a formula for the "YTD" cell in line of the "Buy" item: Iif( [Type] = 'Buy', False, True).
