Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Morning All,
I have a field that is basically a month field, some of the contents of this field are invalid and I have declared them as 'No Forecast'
What I wish to do is start at my total and burn down by month until I reach my No forecast total.
I'm think I am very close but I am obviously missing something. Also my data always seems to want to put No Forecast first when I want it last. Can I force a load order to always but a certain content last no matter what the preceding data is?
The simply count of my Forecast_Month field looks like this, so basically I am trying to get from 116 to 34.............
How about this
Count(TOTAL FORECAST_MONTH) - RangeSum(Above(TOTAL Count(FORECAST_MONTH), 1, RowNo(TOTAL)))
Hi Graham
You can load an inline table as
Dim:
LOAD * Inline [
XDim
1
2
];
Use this in the dimension field as pick(Xdim, FORECAST_MONTH, 'Total')
in the expression write:
pick(Xdim, count([A/C_Tail_Number]), count({<FORECAST_MONTH=>}[A/C_Tail_Number]))
You can force the load order to always but a certain content last no matter what the preceding data by using Wildmatch.
Use Wildmatch(FORECAST_MONTH,'No Forecast') in expression is sort and set the
order as descending.
Regards
Pratyush
Would you be able to share a sample to look at what you have?
Afternoon,
If I follow your steps I result in the below:
While waiting for replies I did have some of my own success with the following Expression:
count(Total(FORECAST_MONTH))- Rangesum(above(Total count(FORECAST_MONTH),0,RowNo(total)))
This results in the following:
Which is close to what I am after but I would ideally like to start on my total of 116.
How about this
Count(TOTAL FORECAST_MONTH) - RangeSum(Above(TOTAL Count(FORECAST_MONTH), 1, RowNo(TOTAL)))
I was so close!!
Although you left a bracket in yourself 😉
Thank You
Graham
Yes I did, fixing that now
In fact, you only seems to have a single dimension... this should work also (without TOTALs)
Count(TOTAL FORECAST_MONTH) - RangeSum(Above(Count(FORECAST_MONTH), 1, RowNo()))
That works too.