Problem to generate Subtotals with more descriptive fields

[gomezc73]

Hello,

   Hi Guys, I have problem with my report, because i have a table with data similar to this:

Category	Code of the product	description of the product	Sales May	Sales April	Var
Bicicletas Standard	M01-01R	Bicicletas STD Roja	120	100	20
Bicicletas Standard	M01-01A	Bicicletas STD Azul	200	230	-10
Bicicletas Standard	M01-01V	Bicicletas STD Verde	120	100	20
Bicicletas Electricas	M02-01R	Bicicletas Electrica Roja	120	100	20
Bicicletas Electricas	M02-01A	Bicicletas  Electrica  Azul	200	230	-10
Bicicletas Electricas	M02-01V	Bicicletas  Electrica  Verde	120	100	20

And I need generate my dashboard with subtotals but including the columns "Code of the product" and "description of the product".

I tried with Matrix but I only can display or de code of the product or de description, but not both of them.

    By example:

                                         Sales May     Sales April      Var
Bicicletas Standard                 440             430             30
        M01-01R                        120             100             20
        M01-01A                        200             230            -10
        M01-01V                        120             100             20
    

  With the Icon "table" I can display all columns i need, but I can't generate subtotals by Category, only it has Grand Totals.

  Is possible In PBI generate a  Matrix or table in the dasboard, with more descriptive fields?(In my real data i have more columns that i would like to display by example Brand, Extras, Rin#, etc)

I would like something like that: (Because my users frecuently download the data to Excel)

Category	Code of the product	description of the product	Sales May	Sales April	Var
Bicicletas Standard	M01-01R	Bicicletas STD Roja	120	100	20
Bicicletas Standard	M01-01A	Bicicletas STD Azul	200	230	-10
Bicicletas Standard	M01-01V	Bicicletas STD Verde	120	100	20
		SUB TOTAL Bicicletas Standard	440	430	30
Bicicletas Electricas	M02-01R	Bicicletas Electrica Roja	120	100	20
Bicicletas Electricas	M02-01A	Bicicletas  Electrica  Azul	200	230	-10
Bicicletas Electricas	M02-01V	Bicicletas  Electrica  Verde	120	100	20
		SUB TOTAL Bicicletas Electricas	440	430	30
		GRAND TOTAL	880	860	60

[FrankAT]

Hi @gomezc73 

take a look at the following solution:

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

[gomezc73]

thank you very much.. thats is just i needed..

Could you please explain me how you get this effect in the matrix??..

[FrankAT · Accepted solution]

Hi @gomezc73 

at the bottom of my first reply you'll find an attached pbix file.

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)