Cube view in dashboard with rows displayed in the middle

Hi Adina , Thats a nice report. I would construct this in excel and use the spreadsheet component to display it in a dashboard.  

Who's your daddy and what does it do? 🙂

First, create a UD8 member that will just return the current POV account name with type DynamicCalc and Member Formula as follows:

If api.View.IsAnnotationType Then
' if you wanted to target a specific view you could use this instead:
' if api.POV.View.Name.XFEqualsIgnoreCase("Annotation") then
   return api.POV.Account.Description
end if

Then create your CV. I'm going to hide icons:

And hide row headers:

First and last columns are up to you, just set the central one like this:

And that's it! You can play around with formatting to emphasize the central column.

NicolasArgente RobbSalzmann would you hire me? 😁

PS: there may be a way to do this with custom DataCell functions, without the extra UD8 member, but I couldn't get it to work because the returned cell is always treated as a number for some reason.