I have a table in the below format:
where the category stretches from X1 to X5 and Time repeats from 1 to 9. s1 to s5 are having independent data entries.
When I convert it into pivot table, I get the below table:
Below is the pivot field selections I made:
My issue here is, I need to toggle the s1, s2, s3, s4 and s5 series. I am able to do the toggling for X1 to X5 series by filtering the Column Label, but no option shows up for s1 to s5 series.
I tried to fiddle around with the value filters, but that is not helping much. I am looking to see if I update the PivotTable Fields in any way to meet my requirement.