Static Straight Table

[Anonymous]

Dear, All

Good Morning!

Today morning I was trying to freeze the straight table values.

I Succeeded to freeze one expression, but I got stuck on other.

So can anyone help me in fixing the other problem?

Thanks in Advance

[Anil_Babu_Samineni]

Looks like you have some values? What are you going to have instead 0's ??

[Anonymous]

Yes, Anil

You are right; Straight table has values. However, as I selected oct month, so it is reflecting oct month value, but i want values for all the months.

It should n't have any link with selection of months.

As an example, I did for the first expression.

[Anil_Babu_Samineni · Accepted solution]

Try this?

=Num(Count({1<Comments = {"Duplicate"}>} Comments), '##,##,###')

[its_anandrjs]

Try this way also

=Num(Count( {1} {<Comments = {"Duplicate"}>} Comments), '##,##,###')

[Anonymous]

Thanks, Chouhan

But this expression is not working.