Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Team,
I have a dataset from Jan 2015 to Mar 2018.
I have used the below function :
Measure : count([Employee #])/above(count([Employee #]))
Dimension Drill Down : Year , Quarter , Month
Year :
The first year does not have value as there is no value above it
On drilldown Year 2017 ,Q4 has null value ,
On drilldown Q1,March has null value.
Ideally Q4-17 should not have null value as it's above function should call Q3-17 and similar for month.
For every selection there is null value for one field value.
How to fix it , is there any alternate mechanism.
Thanks,
Arvind
Thanks for the response Hans.
How excatly RowNo() function will help?
Regards,
Arvind
Maybe I didn't understand your problem fully, but being able to determine wether or not to use the "above()" based on the row number?
Actually in my case it's a drilldown and with "above" function a null value comes at each and every step of a drilldown for 1st value which is not desirable as the value is present for the above rows.