I'm using QVPE. Am i right in thinking I can't share this report? I've attached a screen shot if thats any help...
Looking at the image, if I select a value of say 9 from financial period then the records in the table reflect that. What I want when i select 9 is all records where financial period is less than 10.
What I want when i select 9 is all records where financial period is less than 10.
It's quite simple.
Just add another table to your data model with two fields: financialPeriod and finansialPeriodAndPrev.
The field finansialPeriodAndPrev should be used instead of financialPeriod for selections.
The table should connect finansialPeriodAndPrev (selection periods) with corresponding financialPeriod-s.
So, selection "3" from finansialPeriodAndPrev associated with financialPeriod-s "1","2","3".