on 11-23-2016 3:38 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.