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.
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?
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.
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.