Anyone ever make a pivot/crosstab table for a report? (TTP 53705)
There doesn't seem to be a way to create a pivot table in the ESM. I tried looking in the report template designer and there are instructions for being able to make one but I believe the components are masked or removed; search for "crosstab".
I tried "hard coding" a Trend to have counts of the groups I wanted in individual columns but hit a wall. It came out nicely in a table format but took quite a number of variables (conditional evaluation then convert a string 0 or 1 to int for each column) and because I was manually defining each column if I wanted to add a new column I had to create a new Trend. You also couldn't really use the data in any charts.
Have I overlooked a setting somewhere?
Edit: There was an already existing feature request for this type of report template. TTP 53705. As always please ask support to add your company to this TTP if you think you would benefit from this feature.