Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
morning,
having a nightmare this morning with a really simple problem.
using an SAP schema, so all based around start and end dates.
i have a straight table, with Age_Band as the dimension. The expression is built up of a concatenation of Day, Month and Year with a set expression to count the unique staff id's
the total number calculated is correct, only instead of splitting up the value by the dimension i get the same top level value for each row in the dimension. Ie
Age | Headcount |
---|---|
20 | 1000 |
25 | 1000 |
in the above example 1000 is the sum total, not the values for 20 and 25. i'm doing something stupid im sure.
losing my mind!
Can you share the App or maybe the Expression
May be you need to use Aggr function.
Better is you share sample data or apps !
Use distinct Qualifier.
Please share your qvw.