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

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Similar threads

Forum statistics

Threads
1,223,647
Messages
6,173,544
Members
452,520
Latest member
Pingaware

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