Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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))
it is not working out
Would you be able to share a sample?
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,,
];