I have a straight table where I have 4 dimensions and multiple expressions just showing the value of a cell from a staged excel file.
I need to return specific values through out the straight table. The table has been frozen so it cannot be sorted etc.
Example table below. My 4 dimensions are as of date, partner, partner product, min.max.
I need to be able to pull specific Need values in the columns.
Example: I need to pull the a.2 min needed value 1 and display it in a text object
Then in another text object I need to display the A.2. max value in a text object.
So on and so forth.
Thank you ahead of time!
| As Of Date | Partner | Partner Product | Min/Max | Needed values 1 | Needed values 2 | Needed values 3 | Needed values 4 |
| 1/1/2018 | A | A.1 | Min | test 1 | value 1 | needed 1 | last 1 |
| 1/1/2018 | A | A.1 | Max | test 2 | value 2 | needed 2 | last 2 |
| 1/1/2018 | A | A.2 | Min | test 3 | value 3 | needed 3 | last 3 |
| 1/1/2018 | A | A.2 | Max | test 4 | value 4 | needed 4 | last 4 |
| 1/15/2018 | B | B.1 | Min | test 5 | value 5 | needed 5 | last 5 |
| 1/15/2018 | B | B.2 | Max | test 6 | value 6 | needed 6 | last 6 |
| 1/15/2018 | C | C.1 | Min | test 7 | value 7 | needed 7 | last 7 |
| 1/15/2018 | C | C.2 | Max | test 8 | value 8 | needed 8 | last 8 |
