i want show amount >10 and only show domain "a" in straight table

[Vijayqlik4171]

i have this table 

i need show  like this table

i

[stevejoyce]

This can be your amount measure:

sum({<amount = {">10"}, domain= {'a'} >} amount)

[abhijitnalekar]

Create New dimension like

=if(Amount>10,domain) as NewDimension use this in table and uncheck include null values.

[Vijayqlik4171]

i getting this

i need like this

[stevejoyce]

You're right, what i said was incorrect if you don't have any other dimension to break these values out into rows.

Can use dimensions:

=aggr(only({<domain= {'a'} >} domain), domain)

=aggr(only({<Amount= {">10"} >} Amount), Amount)

[juleshartley]

Just display the amount as a dimension, rather than a measure

[akshatagrawal · Accepted solution]

Hello Vijay,

Please use below solution.

1) Take a table chart

2) Add first dimension as below.

=if(domain='a' and amount>10,domain)

Label it as Domain and uncheck include null values.

3) Add second dimension.

=amount

I hope this helps.

[Vijayqlik4171]

thank you