Entering next level of hierarchy in matrix gives wrong column values

[LParker97]

Hi

I am creating a matrix to present a summary of my clients data to them and I would like it to look like this

Product | Expired  |        A           |                B                |
              |               |  May |  June | June | July  | August |

-------------------------------------------------------------

123        |        12   |   3     |     5    |    7   |    8   |     34     |

456        |        -     |   -      |     -     |    -   |   -    |     -        |

753        |        -     |   -      |     -     |    -   |    -   |     -        |

However when I create the hierachy in the columns and "Expand to the next level", Columns in May become a summary and the results are shifted along so they are underneath the next column header, 

and if I drill down to the next level it only displays the results for each month.

I just want to be able to have all my columns displayed with no summary under each category and sub category

[amitchandak · Accepted solution]

@LParker97 , Not sure I got it. But there expand like reverse square Y,  You can drill till the last level and save there.

https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/

[LParker97]

So I tried fiddling round with the sub totals columns and by enabling sub totals and removing the columns it gave me what i wanted. thanks for the link