Front End Table

[kiranpatil123]

Hi All , I have 1 table

ID	Flag
1	Yes
2
3	Yes
4
5
6	Yes

In Front end Table i Need 

Dimension as ID with Flag is yes	Expression 1 : count of Total ID's	Expression 2 : count of ID's with Flag Yes
1	6	1
3	6	1
6	6	1

How can i get this ?

Please note in Dimension i want to See only ID's with Flag Yes ( 1,3,6 )

Advance Thanks

[sunny_talwar · Accepted solution]

May be this

Expression 1

If(Flag = 'Yes', Count(TOTAL ID))

Expression 2

Count({<Flag = {'Yes'}>}ID)