 | |
About calculated member
microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
About calculated member -
08-06-2004
, 09:51 PM
#2
| |||
| |||
|
|
Dear all, I want to show sales in ($) and (%) at the same time in Excel. However, it seems that the calculated member (sales) can only appear once. I tried to drag it to datafield two times, but nothing happened! Can someone give me suggestion? Best Wishes, Polly |
#3
| |||
| |||
|
|
have you try to create a calculated measure? in your cube, create a calculated measure "sales 2" also, this calculated measure can calculated the % value directly in the cube and not through Excel. "Polly" <Polly (AT) discussions (DOT) microsoft.com> a écrit dans le message de news:780FC9E7-9006-4ABA-B61D-67D5FD31E610 (AT) microsoft (DOT) com... Dear all, I want to show sales in ($) and (%) at the same time in Excel. However, it seems that the calculated member (sales) can only appear once. I tried to drag it to datafield two times, but nothing happened! Can someone give me suggestion? Best Wishes, Polly |
#4
| |||
| |||
|
|
Do you mean I have to duplicate the information for different purpose? Polly P.S. Thanks for your suggestion! "Jéjé" wrote: have you try to create a calculated measure? in your cube, create a calculated measure "sales 2" also, this calculated measure can calculated the % value directly in the cube and not through Excel. "Polly" <Polly (AT) discussions (DOT) microsoft.com> a écrit dans le message de news:780FC9E7-9006-4ABA-B61D-67D5FD31E610 (AT) microsoft (DOT) com... Dear all, I want to show sales in ($) and (%) at the same time in Excel. However, it seems that the calculated member (sales) can only appear once. I tried to drag it to datafield two times, but nothing happened! Can someone give me suggestion? Best Wishes, Polly |
#5
| |||
| |||
|
|
yes, if you want to allow a user un der excel to display real value and % value at the same time. Other client tools can do this without changing your cube (you can directly create a calcuklated measure on the fly) "Polly" <Polly (AT) discussions (DOT) microsoft.com> a écrit dans le message de news:FC784170-A8B1-4C47-B54E-B15FA765E61D (AT) microsoft (DOT) com... Do you mean I have to duplicate the information for different purpose? Polly P.S. Thanks for your suggestion! "Jéjé" wrote: have you try to create a calculated measure? in your cube, create a calculated measure "sales 2" also, this calculated measure can calculated the % value directly in the cube and not through Excel. "Polly" <Polly (AT) discussions (DOT) microsoft.com> a écrit dans le message de news:780FC9E7-9006-4ABA-B61D-67D5FD31E610 (AT) microsoft (DOT) com... Dear all, I want to show sales in ($) and (%) at the same time in Excel. However, it seems that the calculated member (sales) can only appear once. I tried to drag it to datafield two times, but nothing happened! Can someone give me suggestion? Best Wishes, Polly |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.