Data allign in Pivot

[bhuprakash]

Team,

Please check the below Dashboard. I want Active counts row as given in dashboard.

Active = Total - Drop/Opt-out

[bhuprakash]

yes Tresesco,

Exactly I want this. Thanks a lot for your quick support.

Also thank u Anil for your quick help.

[bhuprakash]

But please check =if(dummy=1) like code is showing in column.

Please check this

[tresesco]

You can change the label like:

[Anil_Babu_Samineni]

What if Dummy Field is not available? I meant, If we don't have field with some sequential order. Then, How we can develop?

Just to know - If you have time please reply.

[tresesco]

Dummy is not required to be sequential. It can be anything as an island. And if you don't want a new field in the script, you might have to use synthetic dimension; using valuelist()/valueloop(), which I don't prefer in such cases.