Caption of aggregated values, hide columns


Hi, we are currently evaluating Pivot Table and facing two issues that are maybe easy to solve:

  • We need to change the caption of aggregated values in the attached example (‘$ YTD’ instead of ‘Sum of salesgrossvalue_total_cy’)
  • We like to hide/unhide some of the columns on click, as our default reports are quite detailed. In the attached examples show ‘Sum of salesgrossvalue_total_cy’ only when clicking on the day of the week. Guess that can be solved with clickHandlers, but maybe there is a more elegant way.

Any help especially on the first topic would be highly appreciated as this currently is a show-stopper for our use-case.
Thanks in advance

3 answers

Roman Petrusha Staff July 6, 2016


1. You can define caption in report like this:
measures: [{uniqueName: “salesgrossvalue”, caption: “Price”}, {uniqueName: “Quantity”}], 
2. Sorry, but I’m not sure that I understand your question? Could you please provide more info?

j.strohbehn July 6, 2016

Thanks a lot for your swift reply.
Unfortunately in your example it still end up as “Sum of Price” whereas I like to have “Price” only, as our reports are quite wide and we tend to use abbreviations to keep reports readable. Regarding the second question I found what I was looking for using handlers simply adding measures on demand.

Dmytro Zvazhii Staff July 7, 2016

 Hi Jan,
The only way to configure the component like you want, is to set a new localization file with the empty “grandTotalCaption” and “totalCaption” attributes, here is an example of such localization file If you use .xml report it will look like this
<param name=”localSettingsUrl”><![CDATA[]]></param>
In order to set the different caption for measure, you should add the following:
<measure aggregation=”sum” caption=”PR” active=”true” format=”currency”>Price</measure>.
Here is an example If you want to know more, you can look through our documentation ( Hope it will help.
Best regards,

Please login or Register to Submit Answer