Topic
  • 1 reply
  • Latest Post - ‏2012-12-07T19:13:13Z by SystemAdmin
SystemAdmin
SystemAdmin
15496 Posts

Pinned topic Crosstab: How to write an expression in Filters for showing certain rows?

‏2012-12-05T21:30:21Z |
Hi,

I am using Report Studio to extract data with a crosstab.

The layout of the crosstab looks like:
Store Number Current Week Current Week of Prior Year YTD YTD of Prior Year
***1
***2
***3
......

The intersection values should be Sales figures.

I want to add a filter upon this crosstab, and its purpose should be:
If the sales figure for Current Week is null or 0, don't dsplay the row for the store. In other words, the crosstab only show the rows that have actual sales in Current Week.

For example, if the original data is:
Store Number Current Week Current Week of Prior Year YTD YTD of Prior Year
***1 1003 987 50678 50232
***2 1123 55456
***3 1102 1027 57231 56763
...... ...... ...... ...... ......

The crosstab should generate:
Store Number Current Week Current Week of Prior Year YTD YTD of Prior Year
***1 1003 987 50678 50232
***3 1102 1027 57231 56763
...... ...... ...... ...... ......

How to write the expression in Filters?

Thank you in advance.
Updated on 2012-12-07T19:13:13Z at 2012-12-07T19:13:13Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    15496 Posts

    Re: Crosstab: How to write an expression in Filters for showing certain rows?

    ‏2012-12-07T19:13:13Z  
    One more thing, it is a multi-dimensional source ...