The simple explanation.
I have a report with data for 9 month.
So every line is 1 month.
First column is the month name, second column the amount for that month (already made that a YTD amount).
Now in the 3rd column I want always to show the number of the 1st month (so the starting position).
Was thinking for something like :
=Sum([Amount LC]) Where([Fiscal Period Year(MM/YYYY)]="01/2019")But this gives nothing.
Any other ideas?
rpinxt (BOB member since 2019-01-23)
Well little update.
This seemed to do it, but it did NOT really:
=RunningSum([YTD LOC]) Where([Period]="01/2019")Period = a variable I based on the period object.
But I would not know why I would need runningsum as it is the first month.
Moreover when I use the filter bar and lets say put the period to period 6 it gives no output anymore.
If I then use a Nofilter() then he does show an amount but the amount is totally rubbish and much too high…
Seemed like such a simple thing…Show always the amount for the first periode…
rpinxt (BOB member since 2019-01-23)
Ok took me a while but I found my solution.
Will post it below for if others run into the same problem.
=NoFilter(Sum([Amount LC]) Where([Period]="01/2019");Drill)This did the trick.
Gave met the 01/2019 amount in every line and when filtered it still gives that number in the 1 line filtered.
rpinxt (BOB member since 2019-01-23)