Please suggest better alternative for below case.
I need to distribute data in report based on 2 char separately. Means for Few key figures will split on Calmonth and few will split on CalQuarter and few formulas will be independent of char.
April May June Q1 Q2 YTD
K1 K2 K1 K2 K1 K2 K3 K3 independent of others
1. If I split Key figures based on Calmonth then I cant show results Row as YTD
2. If I put Char in Key figure Column Then I can not add other Formula independently
3. Is there any option to show heading in 2 rows for key figures (Without Char)