@Sam1 - Thank you for posting your query. I believe this can be done using parameters and calculated fields. Please go through the following posts, where a similar technique has been discussed which can provide you with the required relevant idea to try out the implementation at your end. Hope this helps!
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Dynamically change the columns in table | 3 | 386 | December 21, 2023 | |
| Dynamic selection of fields (columns) in a table | 4 | 1203 | October 2, 2023 | |
| Dynamic selection of columns in table | 1 | 1246 | April 11, 2023 | |
| Dynamically change if a field is a row vs column in a pivot table | 3 | 1193 | September 27, 2022 | |
| Hide table column based on parameter | 4 | 893 | September 13, 2023 |