Show Pivot app column results in 2 separate columns

Kevin7859

I am create a pivot table using pivot app, and it takes the 2 columns I am using and places them as a parent child in one column which is fine, but when I try to chart the results there is no way to separate or filter the chart to show either the parent or the child data independent of one another. Is it possible to use helper columns to break out the parent/child data for charting or will the updating of the pivot chart negate the helper columns results?

I want to show the parent as one graph and the child data as a different graph.

Do filters or expand/collapse functions on the pivot table affect the graphs displayed?

SSFeatures

Hi @Kevin7859, this is a great question.

One option is that you can create another sheet and pull all of the data into the new sheet using cross sheet references.

When you have the data in the new sheet, you can use a helper column to determine if the row is a parent or child.

For example:

=IF(COUNT(ANCESTORS([My Column]@row)) = 0, "Parent", "Child")

Then you can use this helper column to filter your data and graph it accordingly.

I hope this helps!

Kevin7859

I have never used the Ancestors command before, does that identify if the column is more than one parent and one child:

+Parent1

+Child1/Parent2

Child2