Questions SSRS Reports on how to customize primary groups (Group BY)

Question

If possible, I would like to ask for help with how to do the following.

As you can see, it shows the list of products on the rows, group by "food category" on the first group by on the column, then another group by "type of food" next to "food category" along with a total.

This task is already completed. What i want is that on second column group by, made somewhat with the help of an expression that:

The second column ground, at the part of Salmon and Tuna, join those two columns into one or make it disappear and just show FISH from the first group by.

And the other and last question, if we have new group by, by date with format 23/01/2023, if i want to change and group by month and year with that date value so we have:

How can i do both things, is that possible?

Thanks.

Answer 1

i resolved the second question. Format the date field inside the primary group so.

I will post it here if someone finds it useful.

First step:

Format the date field with =Format(CDate(Fields!date.Value), "MMMM yyyy")

Second step:

On group date properties, in General, add group expressions:

1. =Year(Fields!date.Value)
2. =Month(Fields!date.Value)

I still need help with:

As you can see, it shows the list of products on the rows, group by "food category" on the first group by on the column, then another group by "type of food" next to "food category" along with a total.

This task is already completed. What i want is that on second column group by, made somewhat with the help of an expression that:

The second column ground, at the part of Salmon and Tuna, join those two columns into one or make it disappear and just show FISH from the first group by.

Thanks and kind regards,