set analysis in straight table

[neha_sri]

hi ,

I I want to incorporate conditional dimension in straight table,How to do so..

eg:

I have data like

state                         id               name          year

haryana                    1               a                    2012

Gujrat                         2               b                    2012

haryana                         3               c                    2013

hp                                   4               d                    2014

I want to make straight table which is having dimensions as state,id and name for only haryana state. and I want to do this filteration in front end..

Thanks in anticipation

[simondachstr · Accepted solution]

You need to put set analysis into the expression {<state={'haryana'}>}.

If you don't have any measures and you're want a straight table nevertheless, I recommend you to put state, id, name as dimensions and add year as an expression using the only() function, e.g. =Only({<state={'haryana'}>} year).

This should work.