Forum Discussion
P_P2595
Helper I
Helper Ihow do I get the previous QTR value without date table
Input:
| Description | Metric | Target | QTR | Value |
1. Strenth Of Services | CS | 0 | QTR1 | 234 |
1. Strenth Of Services | CS | 0 | QTR2 | 123 |
| 1. Strenth Of Services | CS | 0 | QTR3 | 345 |
| 1. Strenth Of Services | CS | 0 | QTR4 | 111 |
2. Enhance | Communities | 0 | QTR1 | 234 |
2. Enhance | Communities | 0 | QTR2 | 123 |
| 2. Enhance | Communities | 0 | QTR3 | 345 |
| 2. Enhance | Communities | 0 | QTR4 | 111 |
Expected Output:
| Description | Metric | Target | QTR2 value | Previous QTR Value |
1. Strenth Of Services | CS | 0 | 123 | 234 |
2. Enhance | Communities | 0 | 123 | 234 |
Please note that I have only QTR data and I want to display previous QTR data based on slicer selection. I don't have a date on the table.
8 Replies
- Ahmedx
Super User
- Ashish_Mathur
Hi,
My preference would be to create a Date table. If you wish to take this approach, then please share/clarify the following:
- Create a year column as well; and
- Clarify whether Q1 if JFM
