Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a Pivot Table. I need to show an hide few specific columns in the Pivot Table. How do I achieve this?
Here, under 2017, I need to show Sum(Value) and Sum(Sample) columns while under 2018, I need to show only Sum(Value) but not Sum(Sample). The entire column should be hidden, no nulls or '-'
Please refer to the sample data QVW file for better understanding. Really appreciate your help guys.
Something like this?
Script changes
Input:
LOAD * INLINE [
Year, Value, Sample
2018, 2, 6
2018, 4, 4
2018, 6, 9
2017, 3, 3
2018, 4, 2
2017, 1, 5
2017, 3, 4
2018, 2, 1
2017, 8, 0
];
Dim:
LOAD * INLINE [
Dim
1
2
];
Dimensions
Year
=Pick(Dim, 'Value', 'Sample')
Expression
Pick(Dim, Sum(Value), If(Year = 2017, Sum(Sample)))
You added wrong file? Can you re attach for us
My bad. Corrected
Any help is really great in this issue
stalwar1 Any insight?
Something like this?
Script changes
Input:
LOAD * INLINE [
Year, Value, Sample
2018, 2, 6
2018, 4, 4
2018, 6, 9
2017, 3, 3
2018, 4, 2
2017, 1, 5
2017, 3, 4
2018, 2, 1
2017, 8, 0
];
Dim:
LOAD * INLINE [
Dim
1
2
];
Dimensions
Year
=Pick(Dim, 'Value', 'Sample')
Expression
Pick(Dim, Sum(Value), If(Year = 2017, Sum(Sample)))
stalwar1 Thank you. You are a Genius