Group straight table rows together

[chriskan]

I'm looking to group my trade_num rows together using the first column group_trade_num exactly how the pivot table has grouped them. Is there anyway I can do this on a straight table? I do not want to remove any rows from my table, but hiding them similarly to the pivot table would be ideal. FYI I cannot use a pivot table as I have text values in my straight table.

[Digvijay_Singh · Accepted solution]

I don't think its possible to group like this in straight table, I didn't understand from 'FYI I cannot use a pivot table as I have text values in my straight table.' Can you elaborate on that?

[chriskan]

Pivot tables are only for numeric values, no? I have text in my data.

[Digvijay_Singh]

It doesn't matter if its text or numeric, no such restrictions. All standard dimensions and measures are permitted AFAIK.

[chriskan]

Is a formula required for columns containing text? As my text columns are automatically blank when I have previously attempted to use a pivot table

[Digvijay_Singh]

No, I think you got some other issue, if possible share some sample data to see whats exactly happening in your case. As I said pivot is no different from other chart in using dimension and measures in terms of data type like numeric or text. If other chart(Straight table, Bar,line) show your data then Pivot must also show it.

[chriskan]

I unfortunately cannot show data due to privacy reason, however I have managed to display text within my pivot table using this formula: =Concat(Distinct [FieldName],','). With this information, would you have any idea as to why my text data does not appear without this formula?

[Digvijay_Singh]

Not sure but looks like you are trying to show your text data using measure instead of a dimension. When you use naked field name as a measure without using aggregation function like Sum/Count/Concat, it shows nulls when you got multiple data for your chart dimension. For example its same as if you got 2 sales value for a product and you are using your Sales field directly as a measure in your chart and product as a dimension field. Sales value will show null because we have multiple values against a product. It will work as a dimension but as a measure we would need aggregation like sum/count/concat etc.

Just my thoughts may be you got some different situations.

[chriskan]

This suggestion completely messes up my pivot table format resulting in my pivot table looking less like a grouped straight table. I shall accept you first response as a solution as it is indeed impossible to group data in a straight table.