avoid columns

[priyarane]

Hi Community,

I am using Pivot table like below.

I wanted to avoid columns if no data, right now no data available in child8 to child13 but in future we will get. How can I achieve it

- Priya

[sunny_talwar]

I don't think this would be possible in pivot table. You can try this with straight table with multiple expressions with show/hide conditions

[swuehl]

What is your expression?

Try something like

=If( Len(Trim( YourExpression)) , YourExpression)

edit:

Or try conditional dimensions, for your child dimensions, so you would need to create a condition that checks if there are any child values available:

For example for Child_8 dimension:

=Count( Child_8 )

Or

=Count( If(Len(Trim(Child_8)), Child_8))

[priyarane]

it is not working out

[sunny_talwar]

Would you be able to share a sample?

[swuehl]

Seems to work for me, using my sample data and the dimension conditions:

LOAD * INLINE [

ID,Child1,Child2, Child3

1,C1, C2,C3

2,C1,C2,

3,C1,,

];