how to calculate the total % in cross tab?

[Cog8i]

is there any one who can tell me that how to calculate the total of % in cross tab...I have a % colum in my report and i want to calculate the total of % col in the end of report. well...Aggregate fuct didn't give me the result that i want...

 

[krrogovin]

Hi!

If you are using a table as a datasource (it's different with cubes as a datasource) in your crosstab, insert a query calculation beneath your primary column. Your formula should look like this:

percentage(measure)

hth

 

[Cog8i]

well...thanks for your reply...but this is not what i want...
i have "sales%" in a cross tab report in Report studio and i want too calculate the "Total" in the end of report...i mean in the end it should be calculated seperatly...but its not ...its just sum up the all values...like...200%

in list report we can calculate but not here

 

[jjb373]

Could you please give an example of sales percent and what you are looking for with a total??

Sales %
60
50
90
_____
Total??

Any type of picture or clarification would help.

Thanks.


-- JJB373 --

 

[Cog8i]

in cross tab report. In list we can do it easily but not in cross tab report

Sales | Sales%
_________________
Product| 10 | 16.6
_______| 20 | 33.3
| 30 | 50
|

-----------------
Total 60 | 100%

 

[Cog8i]

in cross tab report. In list we can do it easily but not in cross tab report

Sales | Sales%
_________________
Product| 10 | 16.6%
_______| 20 | 33.3%
| 30 -| 50%
|

-----------------
Total 60 | 100%

 

[jjb373]

So you are looking for your Total Sales % to = 100% ??

According to the picture, that is what you will end up with if you divide each product sales # by the total sales.

If for example, you are getting your total sales % to equal 200% then how are you computing Sales %.

In good reporting practice, you don't really want to total percentages because a percentage value like 16.6% should be the result of a calculation. For percentages, you should do an average calculation.

Example. Maybe you have the following:
#Sales #AvailableForSale | %Sales
Product 1 10 50 50%
Product 2 30 45 67%
__________________________________________________
40 95 42%

If what you are wanting to do is show that all of "N" items = 100% then it should be assumed that when you total all the above percentages the outcome is 100% as a whole.

I don't want to tell you how to do something - just giving you some concepts/ideas to think about.




-- JJB373 --