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?
Hi danextian,
1. If in both the filters the values are seleted as same like "R1" in Version 1 and "R1" in version 2, then the counts will be 0 as there is no change. If "R2" in Version 1 and "R1" in version 2 & vise versa is seleted then the elements which has difference should be counted.
2. Same condition as I have explained above between the the version 1 and version 2 selection it should check how many attributed got changed and should be counted.Hope this helps.
