Summary Total Text in BIEE
By Tim Dexter on May 08, 2009
Don't panic, we're not turning into a BIEE blog, I have been doing dome work with it lately and could not find the following nugget out there. Colleagues on an internal list helped out with my request - it was a simple one but I wanted to record it for posterity.
As many of you have seen you can generate totals and sub-totals in your BIP templates quite easily, you can also embed fields into the total label text.
To get the customers name in the total text, its just a case of copy and pasting the customer name field into the table cell.
I needed to do the same in a BIEE pivot table. Not quite so obvious but doable, once I got some help from my friends, ooooh I get by with a little help from my friends ... danged Guitar Hero! I dont even like the Beatles, for a Brit, sacrilege I know.
Building out the pivot you can see that if you set a total for the group you get XXXXX Total.
the dialog to customize the total string is tucked away a little. Click the total icon again and select Format Labels
This will pop the dialog
You can now enter the text you want, the '@' character will be replaced at runtime with the actual group value.
The pivot now renders with the required text.