Expression value should not change on adding new dimesnsion

[#1]

Hi Team,

I have a situation, where if I add new dimension in tables, expression value should not change.

Like I am calculating Spend/Employee across 2 departments and in this case total spend has to be divided with total employees,

thus department in dimension should not affect my calculation of Count of Employee.

PFA the sample data.

Regards,

Navdeep

[Gysbert_Wassenaar]

Try count(total <Month> DISTINCT Name)

[Clever_Anjos]

count(Total <Month> DISTINCT Name) should handle your requirement

[Anonymous]

You are talking about Selection of Department filter or addition of Department dim in table?

For Selection , we can by pass in SET.

if we are adding a dimension and expression value is not changing then what would be the advantage of adding?

[#5]

Hi Total <Month> is not solving the issue, I should be able to see all departments in table but all should have same value for same month in expression.

[#6]

Hi,

I am talking about adding new dimension Department in table, it's adding advantage is because I dont need headcount of department, I need overall headcount.

[#7]

Tried, not working. Could you please try it on attached qvw.

[Anonymous]

will this work?

[Clever_Anjos]

Maybe I am not understanding your need.

It seems to work here