Forum Discussion

gomezc73's avatar
gomezc73
Icon for Helper V rankHelper V
6 years ago
Solved

Problem to generate Subtotals with more descriptive fields

Hello,

 

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

   

CategoryCode of the productdescription of the productSales MaySales AprilVar
Bicicletas StandardM01-01RBicicletas STD Roja12010020
Bicicletas StandardM01-01ABicicletas STD Azul200230-10
Bicicletas StandardM01-01VBicicletas STD Verde12010020
Bicicletas ElectricasM02-01RBicicletas Electrica Roja12010020
Bicicletas ElectricasM02-01ABicicletas  Electrica  Azul200230-10
Bicicletas ElectricasM02-01VBicicletas  Electrica  Verde12010020

 

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)

   

CategoryCode of the productdescription of the productSales MaySales AprilVar
Bicicletas StandardM01-01RBicicletas STD Roja12010020
Bicicletas StandardM01-01ABicicletas STD Azul200230-10
Bicicletas StandardM01-01VBicicletas STD Verde12010020
   SUB TOTAL Bicicletas Standard44043030
Bicicletas ElectricasM02-01RBicicletas Electrica Roja12010020
Bicicletas ElectricasM02-01ABicicletas  Electrica  Azul200230-10
Bicicletas ElectricasM02-01VBicicletas  Electrica  Verde12010020
   SUB TOTAL Bicicletas Electricas44043030
  GRAND TOTAL88086060
  • FrankAT's avatar
    FrankAT
    6 years ago

    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)

     

3 Replies

    • gomezc73's avatar
      gomezc73
      Icon for Helper V rankHelper V

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

       

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

       

      • FrankAT's avatar
        FrankAT
        Icon for Community Champion rankCommunity Champion

        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)