Forum Discussion
Need help filtering dates with a Period slicer !
Hi all, i am trying to calculate a last period revenue figure, i.e sum the value of the sales of accounts b H1[Final Amount] is the revenue (calculation) H1[ posting date] are the order dates L...
Hi Anonymous
for example
| YEAR_ENDING | PERIOD | POSTING_DATE | NAV_NO_CODE | NAV_NO_DESCRIPTION | Customer Number | Customer | DOCUMENT_NO | QUANTITY | Revenue | CUSTOMER_NAME | MANUFACTURER | Revenue Group | Hierarchy Level 3 |
| 2018 | 1 | 01/01/2018 | NX-11111 | Heinz | ACC155 | INVOICE123 | 1 | 20 | Newci | Heinze | CONDIMENTS | TEA | |
| 2018 | 1 | 01/03/2018 | KTCH1 | Ketch | ACC155 | INVOICE125 | 1 | 15 | DALE | Heinze | CONDIMENTS | LUNCH | |
| 2018 | 1 | 01/01/2018 | SLDCRM1 | SALAD | ACC156 | INVOICE126 | 6 | 200 | BOROM | WORCESTER | CONDIMENTS | LUNCH |
HI Anonymous,
Maybe you can take a look at following link:
Slicers For Selecting Last "X" Periods
Regards,
Xiaoxin Sheng