Have you used the calculated field in the second worksheet? also, can you plz elaborate your issue.
If you can see the images, you will notice they are two different worksheets.
Each with the calculated field "Quarter Date" ! On the first image, Q1, Q2, Q3, Q4 and august are shown at the bottom (meaning) the calculated field works.
However, on the second image, you will notice under each quarter (K1 or K2 or K3) August, Q1 and Q2 are are shown. In this case, when I hide the quarter heading, its shows august, Q1 and Q2 under each K1 or K2 or K3. Which it shouldn't.
Is this more clear or gibberish ?
The solution to my problem was to hide value less rows !