Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I have Concatenate 3 Fact table .. Fact A, B , C . But in Fact B i have two Subgroup B1 and B2 as well...
[Sales Master]:
Location,
Sales,
'Sales A' as Flag
from Sales A table;
Concatenate([Sales Master])
Location,
Sales,
Style as SubFlag,
'Sales B' as Flag
from Sales B table;
Concatenate([Sales Master])
Location,
Sales,
'Sales C' as Flag
from Sales C table;
In want to Show Each Sales in KPI on same DashBoard.
1st KPI Expression : sum({ <Flag ={ 'Sales A'}>} Sales)
2st KPI Expression : sum({ <Flag ={ 'Sales B'}>} Sales)
3st KPI Expression : sum({ <Flag ={ 'Sales C'}>} Sales)
4st KPI Expression : sum({ <SubFlag ={ 'Sales A'}>}Sales)
5st KPI Expression : sum({ <SubFlag ={ 'Sales A'}>} Sales)
I have Two List Box for Flag and SubFlag
1 St List Box
Flag |
---|
Sales A |
Sales B |
Sales C |
And
SubFlag |
---|
Top |
Bottom |
But When Customer selecting List Box Value other KPI value show 0. Say Example
Cust Selected Sales B than on KPI 2 Shows Sum(Sales) for B table .. But Other KPI shows ZERO...
I want if cust select any List box value either in Flag or Subflag it Just ignore the selection ..
Means if cust select Subflag Top.. Still All kpi shows its value as per there Expression.
Hi ,
some changes .. that i written previously
4st KPI Expression : sum({ <SubFlag ={ 'Top'}>}Sales)
5st KPI Expression : sum({ <SubFlag ={ 'Bottom'}>} Sales)
It seems weird that its doing that. Because ideally once you have told the expression that look at Flag = 'Sales A', it should not change the result of expression based on any selection in Flag field. Would you be able to share a sample where this is happening?
When you select a value in the SubFlag list, you are limiting the data to those rows that match the SubFlag selection. Using Set Analysis to <Flag ={ 'Sales A'}> is an additive selection, it does not not remove the SubFlag selection.
For those flags that don't have a SubFlag, you should add a modifier to ignore SubFlag.
sum({ <Flag ={ 'Sales A'}, SubFlag=>} Sales)
-Rob