Dynamic Row Visible formula in Crosstab

jeanful — Sat, 23 Aug 2025 15:11:01 GMT

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).

It does not work. Why?

Re: Dynamic Row Visible formula in Crosstab

jeanful — Wed, 27 Aug 2025 16:35:56 GMT

Anyone who has any suggestion? 😞

topic Dynamic Row Visible formula in Crosstab in Reporting Service & Alerting

Dynamic Row Visible formula in Crosstab

Re: Dynamic Row Visible formula in Crosstab