Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My data model has one person associated to many programs, and each program has many attributes. I'd like to be able to show something like:
person1 - program 1:1 - att1 - att2 - att3
- program 1:2 - att1 - att2 - att3
person2 - program 2:1 - att1 - att2 - att2
- program 2:2 - att1 - att2 - att3
If I create a series of list tables, selections don't show attributes per program, just all attributes across many programs that occur within the set bounded by the selected persons.
If I create a chart type = table, I get lost.
Could you please point me in a useful direction, or let me know where a tutorial or reference can be helpful?
Make a pivot table (chart) with Person as first dimension, Program as second and Concat(distinct Attribute, ',') as Expression
HIC
Make Pivot Table Is Possible To Show The Multi Dimension Table in Dimension Wise