can you attach sample data. I can't copy this.
- Drag GPID to Rows
- Drag Week No To Cols.
- Redefine your Level as Numeric - 1,2,3
- Drag that to your marks /abc.
- Create a table calculation Type "Difference from", Compute Using "Table(across)", Relative to "Previous" - wherever your result is 2, you have a high-to-low.
You won't be able to filter by this though, but it's a start.
Thank you looking into the problem.
The above solution is valid if a have a smaller data set. My actual data set is a heavy one and looking manually would be tough one.
I even tried with Grand Totals and then filter. But it didn't work too.
We need to look for a another highlighting solution.
Check Screenshot and attached. It is a bit complex. So first you need to convert your level to numeric values by this formula:
Then I wrote few LODs to get what you Need. So finally you get this number for the number of GPIDs changed between 2 weeks. All the LODs are in attached. Please follow them there.
Hope it Helps!!!
Finding Changes.twbx 23.0 KB
Couple of layers' table calculation are needed.
Specify the first condition by ID
Specify 2nd condition by ID
Count "ID" which met both conditions
To Ignore ID as summary table, add window_sum
To filter the view (hide duplicated ID), add idex filter.
Shin << Ambassador Spotlight Here ! >>