Skip to Content
0

Calculated Member format and with

Nov 23, 2016 at 03:38 AM

55

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Abhilash Kumar
Nov 23, 2016 at 02:59 PM
0

Hi Noelia,

Here's what you need to do:

1) Right-click the column header for the Percentage column (while in the Preview Mode) > Select Calculated Member > Edit Column Value Formula > Type in "Percent".

2) Next, Right-click one of the summary cells > Format Field > Number tab > Customize > Currency Symbol tab > Check 'Enable Currency Symbol' > Under Position choose '(123)$' > Click the formula button beside 'Currency Symbol' > and use this code:

if GridLabelAt("Database.Field", CurrentRowIndex) = "Percent" then

"%"

else ""

Notice how the "Database.Field" is enclosed in double-quotes. Replace that with the field you've used as the Column in the Crosstab.

Hope this helps.

-Abhilash

Share
10 |10000 characters needed characters left characters exceeded