Forum Discussion
Dynamic summary table
Hi All, I have unique requirement in creating a summarized table that should be shown as a matrix or table view based on the selections used in the filters. I have explained the scenario in the b...
Attached the same data as requested. danextian
| Project | ProjectID | Category | Divison Name | Revision | Attribute | Value |
| P1 | 234 | Wall | Structure | R1 | Description | Concreate |
| P1 | 234 | Wall | Structure | R2 | Description | Wood |
| P1 | 234 | Wall | Structure | R3 | Description | Wood |
| P1 | 234 | Beam | Structure | R1 | Tag | B123 |
| P1 | 234 | Beam | Structure | R2 | Tag | B124 |
| P3 | 344 | Roof | Design | R1 | Supplier | Jimm |
| P3 | 344 | Roof | Design | R2 | Supplier | Jimm |
| P3 | 344 | Roof | Design | R3 | Supplier | Harry |
| P2 | 500 | Wall | Structure | R1 | Description | Concreate |
| P2 | 500 | Wall | Structure | R2 | Description | Wood |
| P2 | 500 | Wall | Structure | R3 | Description | Wood |
Hi Mohanraj87
I am trying to wrap my head around your use case but I'm having a hard time doing so.
Please correct my understanding. For 234:
- R1 is in the sample output but not R2 because your first filter is the rows you want to show and to be compared against the second fitler. If the value is different, then then value should return modified and if the same value?
- What if slicer 1 is R2 and slicer 2 is R1? What if R1 and then R3?