# Cross tab grouping

**URL:** <https://forum.inductiveautomation.com/t/cross-tab-grouping/17057>\
**Category:** Ignition\
**Created:** [February 20, 2018, 5:49pm UTC](https://forum.inductiveautomation.com/t/cross-tab-grouping/17057 "2018-02-20T17:49:27Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mrogers](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mrogers/32/4110_2.png) [@mrogers](https://forum.inductiveautomation.com/u/mrogers)\
**Post date:** [February 20, 2018, 5:49pm UTC](https://forum.inductiveautomation.com/t/cross-tab-grouping/17057/1 "2018-02-20T17:49:27Z")

</div>

I made a pivot table in Excel out of some data I exported from Ignition and I’ve been asked to make this available directly in Ignition. I’m trying to recreate this in Reporting using the CrossTab component and have part of it working - just need to add the secondary grouping here on the rows at least. I can see essentially the total rows, but not broken out by type as a secondary grouping. I’m trying to mess around with it but no luck so far - does anyone have any suggestions? I don’t care as much about the column grouping, I think I can combine those into one cell each if needed.

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/c/c2dab1a5c8400e4b5df897effd9917081e264b1d.png)

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [February 20, 2018, 6:17pm UTC](https://forum.inductiveautomation.com/t/cross-tab-grouping/17057/2 "2018-02-20T18:17:16Z")

</div>

I think you can use the PIVOT clause of my [view() expression function](https://www.automation-pros.com/simaids/doc/expression.view.html) from the [Simulation Aids module](https://inductiveautomation.com/moduleshowcase/module/automation-professionals-llc-simulation-aids) in the report designer. Haven’t tried it myself, though…

---

<div class="post-metadata">

**Author:** ![mrogers](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mrogers/32/4110_2.png) [@mrogers](https://forum.inductiveautomation.com/u/mrogers)\
**Post date:** [February 20, 2018, 6:27pm UTC](https://forum.inductiveautomation.com/t/cross-tab-grouping/17057/3 "2018-02-20T18:27:44Z")

</div>

Thats interesting, and I have thought about that module a bit, but I’m not sure I could convince the guys who run the gateway to install it, despite it being free. I’ll bring it up the next time I talk with them though.