Ignore calculated dimension in pivot table

[#1]

I have a table below:

Column dimension: if(flag=0, 'local', 'XB')

Row dimension: time_bucket

Expression:

1. count(id)

2. count(id) / count(total <flag> id)

What I want to show:

How ever now it's not working, it's showing percentage as over 500 instead of 100 or 400.

Any thoughts?

By the way, this expression works if the dimension is not a calculated one. Tested. So weird.

[Anil_Babu_Samineni]

Due to Total it may behavior. Try to remove that and check

2. count(id) / count({<flag>} id)

[#3]

This gives me 100% for all cells.

[Anil_Babu_Samineni]

Would it possible to share sample and expected result. That would be more helpful

[#5]

It's weird. I tried this expression in both QlikView and Qlik Sense. It works fine in QlikView but not in Sense.