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 below screenshot as what the output should look. Kindly provide the suggestion, feedback and solution to the problem.
Regards,
Mohanraj
6 Replies
Why would you include the revision column in the output? And, rather than stating "Modified" I would list the actual before and after values.
Yes. I agree with you lbendlin that "Revision" column is not required. But, the "Modified" value is the business requirement. But, your logic is correct. Let me know if there is way to build the summary table.
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?
