Forum Discussion

psc's avatar
psc
New Contributor III
7 days ago
Solved

Headers in center of excel

Hello, I know you can center columns in a report, but is there a way to do this for cube views exporting to excel? I've only found a workaround where you go to export it to report and then change it...
Cube View
Excel Add In
Reports
  • CAIGuySeanF's avatar
    CAIGuySeanF
    4 days ago

    Hey there, not sure if this is what you're looking for but I've uploaded text and used formulas to populate annotation (view).  Once done, you can retrieve in your grid just like other financial data intersections.  

    *Having trouble getting images to upload, but hopefully you can see visuals now*

psc's avatar
psc
New Contributor III
6 days ago

Hi Marcus, I mean to have the entire column in the center - so let's say periodic on the left then the account names in middle and ytd on the right. The above just centers the name of the cell within the cell. I'm on version 8.5 (exciting)!

CAIGuySeanF's avatar
CAIGuySeanF
Contributor
4 days ago

Hey there, not sure if this is what you're looking for but I've uploaded text and used formulas to populate annotation (view).  Once done, you can retrieve in your grid just like other financial data intersections.  

*Having trouble getting images to upload, but hopefully you can see visuals now*

  • CAIGuySeanF's avatar
    CAIGuySeanF
    Contributor
    4 days ago

     

  • psc's avatar
    psc
    New Contributor III
    22 hours ago

    Thank you! I think this is the best work around for now.