Skip to Content
0
Former Member
Nov 23, 2016 at 03:38 AM

Calculated Member format and with

86 Views Last edit Nov 07, 2017 at 06:36 PM 2 rev

Hello

I have these set of data

requisition_id item vendor quote_id material labour price

the client want to see the following information, and i created a cross tab to pivot the vendor information for a side to side comparison of quotes

vendor 1 vendor 2 vendor 3

material cost 10 | 50% .....

labour cost 10 | 50% ......

price 20 |100% .....

I have successfully created a cross tab with a column group of vendor and

summaries max(material cost) , max(labour cost) , max(price cost)

also added a calculated member to get the %of price on each category

this is how my cross tab looks like now :

vendor 1 % vendor 2 % vendor 3 %

material cost 10 50 .....

labour cost 10 50......

price 20 100.....

I want to add the % sign to the % column .. how can i achieve it ( is a calculated member)

I want to be able to modify the width of the % column , if i modify the width of the column the

summary column width is also modified ...

Also , is it possible to move the % calculated member column under the vendor group, is so .. how to do it ?

Thanks in advance