Power BI - Moving Headings

Vegas01

New Member
Joined
Jun 15, 2021
Messages
43
Office Version
  1. 2019
Platform
  1. Windows
Hi everyone

I was wondering how do I get the the title (hightlighted in bold) to replace the Total (in red) in the each section of data or at least putting the heading on the same line with the total?

In the CSV file we receive, it groups type of data together, what I need it the total amounts, for invoicing purposes. (I had a thought of something like everytime you have a blank line do this???)

I hope I have explained it well enough.

Thanks in advance.



__MPS Packed Patient Days__
WardBulk Order Days@TotalCD Bulk Order Days@TotalCD Mixed Bulk Order Days@Total
A1
889​
0.01​
8.89​
0​
0.01​
0​
0​
0.01​
0​
A2
455​
0.01​
4.55​
0​
0.01​
0​
0​
0.01​
0​
A3
630​
0.01​
6.30​
28​
0.01​
0.28​
0​
0.01​
0​
A4
532​
0.01​
5.32​
0​
0.01​
0​
0​
0.01​
0​
A5
21​
0.01​
0.21​
0​
0.01​
0​
0​
0.01​
0​
Total
2527​
25.27​
28​
0.28​
0​
0​
__Courier Fees__
DateCost
TOTAL
0​
__Fractional Tablets__
FractionsWithoutAlternativeFractionsWithoutAlternativeFeeFractionsWithAlternativeFractionsWithAlternativeFee
1616​
0.01​
0​
0.01​
__Chart Care__
Signing SheetsPagesSummary SheetsPagesNRMC SheetsNRMC PagesFeeNRMC FeeTotal
Aged Care by MPS
0​
0​
0​
0​
0​
0​
0.10​
0​
0​
Community by MPS
0​
0​
0​
0​
0​
0​
0.10​
0​
0​
Aged Care in Pharmacy
0​
0​
1​
4​
0​
0​
0.10​
0​
0.2​
Community in Pharmacy
0​
0​
0​
0​
0​
0​
0.10​
0​
0​
Totals
0​
0​
1​
4​
0​
0​
0.2​
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Similar threads

Forum statistics

Threads
1,225,397
Messages
6,184,716
Members
453,254
Latest member
topeb

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top