Forum Discussion

JamesCH's avatar
JamesCH
Frequent Visitor
10 years ago
Solved

Report Sub Totals within a report

Have been given a data set and a layout from an excel spreadsheet which is wanted to be shown in Power BI.

 

 

 

 

Not quite sure the best way of doing this as a Power BI Novice. Not even sure of this is the right use pf Power BI.

 

Any help and advice on this would be welcome

Need Help
  • Anonymous's avatar
    Anonymous
    10 years ago

    JamesCH If you are asking if the layout is possible, then yes. Here is a quick example of using a Matrix to show a example of your report. You may need to build some measures for certain calculations, but if your goal is to produce the same look, you should be able to. Note in this sample, I've used just a custom style, all the colors and lines are formatable to achieve the color scheme you are looking for.

5 Replies

  • BhaveshPatel's avatar
    BhaveshPatel
    Icon for Super User rankSuper User
    10 years ago

    Hi There, 

     

    Please post your sample data file to suggest a solution. 

     

     

    Thanks & Regards,

    Bhavesh

    • JamesCH's avatar
      JamesCH
      Frequent Visitor
      10 years ago
      TonnesProductYearMonthRegionGross ValueDelivered PriceStandardVariableType
      3.62PROD A2016AprilRegion A1,840.631,840.631,629.72998.07TYPE A
      6.03PROD A2016MayRegion A3,085.713,085.712,716.511,663.63TYPE A
      7.81PROD A2016JuneRegion A4,028.894,028.893,567.782,153.56TYPE A
      3.96PROD A2016JulyRegion B2,010.962,010.961,773.061,090.43TYPE B
      7.64PROD B2016AugustRegion B3,886.613,886.613,425.972,106.97TYPE B
      4.02PROD B2016SeptemberRegion C2,072.472,072.471,800.851,107.52TYPE B
      0PROD B2016AprilRegion D6,706.766,706.760.000.00TYPE A
      23.89PROD C2016MayRegion A12,767.9312,767.9310,753.486,585.59TYPE A
      21.82PROD C2016JuneRegion B11,661.9711,661.979,822.016,015.14TYPE A
      23.83PROD A2016JulyRegion A12,739.6012,739.6010,886.066,570.97TYPE B
      7.87PROD A2016AugustRegion A4,277.564,277.563,124.762,170.38TYPE B
      3.92PROD A2016SeptemberRegion A2,078.862,078.861,756.471,080.23TYPE B
      3.97PROD A2016AprilRegion B2,126.732,126.731,781.581,095.67TYPE A
      11.93PROD B2016MayRegion B6,383.956,383.955,347.873,288.93TYPE A
      1.56PROD B2016JuneRegion C1,124.641,124.64713.47430.66TYPE A
      2.01PROD B2016JulyRegion D1,101.571,101.57891.95543.06TYPE B
      18.04PROD C2016AugustRegion A10,102.6510,102.658,016.024,880.47TYPE B
      22.08PROD C2016SeptemberRegion B12,117.8512,117.859,625.245,973.89TYPE B
      20.2PROD A2016AprilRegion A11,311.3611,311.368,804.315,464.38TYPE A
      2.03PROD A2016MayRegion A1,135.341,135.34883.70548.47TYPE A
      2.02PROD A2016JuneRegion A1,105.961,105.96882.28545.22TYPE A
      9.95PROD A2016JulyRegion B5,704.305,621.384,423.772,693.36TYPE B
      1.94PROD B2016AugustRegion B1,112.321,096.15862.62525.20TYPE B
      11.85PROD B2016SeptemberRegion C6,636.446,537.755,265.503,205.84TYPE B
      3.91PROD B2016AprilRegion D2,188.432,155.881,736.351,057.16TYPE A
      5.79PROD C2016MayRegion A3,244.843,196.582,574.531,567.48TYPE A
      13.92PROD C2016JuneRegion B7,794.237,678.326,184.123,765.13TYPE A
      2PROD A2016JulyRegion A1,120.261,103.60888.84541.16TYPE B
      24.01PROD A2016AugustRegion A13,443.7513,243.7910,668.336,495.30TYPE B
      2PROD A2016SeptemberRegion A1,117.751,101.12887.06540.08TYPE B
      2.04PROD A2016AprilRegion B1,144.641,144.64908.40553.07TYPE A
      21.81PROD B2016AprilRegion B12,213.0412,213.049,692.385,901.10TYPE A
      12.19PROD B2016AprilRegion C6,912.296,790.385,314.853,298.65TYPE A
      7.86PROD B2016AprilRegion D4,456.054,377.463,426.252,126.50TYPE B
      23.37PROD C2016MayRegion A12,201.3912,201.3910,223.996,330.26TYPE B
      23.5PROD C2016JuneRegion B11,964.1511,964.1510,280.426,365.20TYPE B
      24.29PROD A2016JulyRegion A12,033.6012,033.6010,623.816,577.81TYPE A
      22.84PROD A2016AugustRegion A11,319.9011,319.9010,184.406,186.17TYPE A
      14.11PROD A2016SeptemberRegion A6,994.156,994.156,199.943,822.21TYPE A
      4.04PROD A2016AprilRegion B1,999.821,999.821,772.731,092.87TYPE B
      10.13PROD B2016AprilRegion B5,123.865,123.864,450.492,743.69TYPE B
      24.03PROD B2016MayRegion C12,155.1312,155.1310,512.266,508.75TYPE B
      4.03PROD B2016JuneRegion D2,152.852,152.851,794.761,090.16TYPE A
      22.5PROD C2016JulyRegion A12,132.1012,132.1010,031.906,093.54TYPE A
      22.96PROD C2016AugustRegion B12,380.2012,380.2010,087.206,218.67TYPE A
      24.45PROD A2016SeptemberRegion A13,186.3413,186.3410,903.646,623.05TYPE B
      10.21PROD A2016AprilRegion A5,504.695,504.694,551.772,764.82TYPE B
      14.27PROD A2016MayRegion A7,692.987,692.986,361.243,863.92TYPE B
      8.02PROD A2016JuneRegion B4,291.804,291.803,525.252,173.28TYPE A
      11.99PROD B2016JulyRegion B6,466.186,466.185,245.413,247.74TYPE A
      4.01PROD B2016AugustRegion C2,162.762,162.761,788.511,086.37TYPE A
      8.04PROD B2016SeptemberRegion D4,333.614,333.613,583.712,176.81TYPE B
      23.96PROD C2016AprilRegion A12,919.9512,919.9510,481.646,489.79TYPE B
      2.02PROD C2016AprilRegion B1,080.441,080.44900.72547.11TYPE B
      2.04PROD A2016MayRegion A1,089.531,089.53908.30551.72TYPE A
      7.37PROD A2016JuneRegion A3,941.993,941.993,223.981,996.15TYPE A
      24.44PROD A2016JulyRegion A11,711.9811,711.9810,897.406,619.25TYPE A
      12.04PROD A2016AugustRegion B6,744.566,644.235,370.443,262.09TYPE B
      4.02PROD B2016SeptemberRegion B2,249.492,216.031,791.191,088.00TYPE B
      4.05PROD B2016AprilRegion C2,301.882,268.121,780.641,097.75TYPE B
      1.97PROD B2016MayRegion D1,134.871,118.46865.50533.57TYPE A
      1.8PROD C2016JuneRegion A1,006.00991.04789.05486.44TYPE A
      5.76PROD C2016JulyRegion B3,224.683,176.722,529.271,559.27TYPE A
      3.56PROD A2016AugustRegion A2,025.621,995.941,565.36965.03TYPE B
      22.19PROD A2016SeptemberRegion A11,676.5511,676.559,749.356,010.39TYPE B
      24.34PROD A2016AprilRegion A12,804.6912,804.6910,691.296,591.09TYPE B
      23.5PROD A2016MayRegion B12,366.3712,366.3710,325.326,365.47TYPE A
      1.98PROD B2016JuneRegion B1,035.191,035.19870.33536.55TYPE A
      22.77PROD B2016JulyRegion C11,709.3411,709.349,960.216,166.94TYPE A
      2.04PROD B2016AugustRegion D1,047.051,030.09907.86551.45TYPE B
      1.93PROD C2016SeptemberRegion A989.99973.95858.81521.65TYPE B
      1.79PROD C2016AprilRegion B888.35888.35780.84483.46TYPE B
      15.68PROD A2016AprilRegion A7,802.647,802.646,860.034,247.44TYPE A
      22.94PROD A2016AprilRegion A11,750.0411,750.0410,035.456,213.52TYPE A
      24.1PROD A2016MayRegion A12,077.6711,908.9610,746.686,527.71TYPE A
      9.94PROD A2016JuneRegion B4,979.704,910.144,430.932,691.42TYPE B
      1.89PROD B2016JulyRegion B949.14935.88844.54512.99TYPE B
      17.82PROD B2016AugustRegion C8,930.598,805.847,795.734,826.78TYPE B
      1.97PROD B2016SeptemberRegion D986.22972.44860.89533.03TYPE A
      2.06PROD C2016AprilRegion A1,019.441,005.00902.45558.76TYPE A
      2.01PROD C2016AprilRegion B991.76977.71877.95543.59TYPE A
      17.11PROD A2016AprilRegion A8,447.008,327.247,628.494,633.67TYPE B
      4.04PROD A2016MayRegion A1,991.631,963.321,803.231,095.31TYPE B
      4.04PROD A2016JuneRegion A1,995.881,967.611,801.001,093.96TYPE B
      4.05PROD A2016JulyRegion B2,002.801,974.431,807.241,097.75TYPE A
      2PROD B2016AugustRegion B989.87975.84893.59542.78TYPE A
      1.98PROD B2016SeptemberRegion C994.24980.35871.65537.36TYPE A
      12.07PROD B2016AprilRegion D6,047.115,962.645,301.493,268.32TYPE B
      1.76PROD C2016AprilRegion A870.76858.42771.22477.51TYPE B
      1.96PROD C2016MayRegion B983.71969.97858.71531.67TYPE B
      11.94PROD A2016JuneRegion A5,881.805,798.205,224.423,234.74TYPE A
      17.05PROD A2016JulyRegion A8,546.448,427.077,459.774,618.77TYPE A
      12.18PROD A2016AugustRegion A5,997.055,911.815,429.753,298.12TYPE A
      16.17PROD A2016SeptemberRegion B7,990.457,877.267,210.244,379.61TYPE B
      • Anonymous's avatar
        Anonymous
        Not applicable
        10 years ago

        JamesCH If you are asking if the layout is possible, then yes. Here is a quick example of using a Matrix to show a example of your report. You may need to build some measures for certain calculations, but if your goal is to produce the same look, you should be able to. Note in this sample, I've used just a custom style, all the colors and lines are formatable to achieve the color scheme you are looking for.