Show Quarterly % in Expression

[ajaysingh285]

Hi Members,

I am not able to group the expression in percentage on the basis of quarter.

I have the scenario given below:-

Quarter(as Dimension)	Sum(expression1)+Sum(expression2)
	$313,962.93
Q1	$36,260.47
Q1	$24,627.60
Q1	$26,368.20
Q2	$27,909.51
Q2	$26,747.78
Q2	$27,576.78
Q3	$25,242.10
Q3	$24,848.75
Q3	$24,820.91
Q4	$23,270.59
Q4	$20,847.45
Q4	$25,442.78

i am having Quarter as Dimension and other as sum of two expression. so the sum ( exp1 and exp2) which total is bifurcate to different quarters which is good.

But my question is , i need the percentage of  each Quarter. like percentage for Q1,Q2,Q3,Q4?

Can any body help me out from this?

[sunny_talwar]

What is the expected output for the sample data provided?

[ajaysingh285]

Sum(Q1$value)/sum(Q1$ value+Q2$ value+Q3$ value+Q4$ value)  *100 respectively for  Q2 ,Q3,Q4 which is in percentage form

[sunny_talwar]

Something like this

(Sum(expression1)+Sum(expression2))/(Sum(TOTAL expression1)+Sum(TOTAL expression2))

[ajaysingh285]

i have tried sum(total) but it shows blank. Do u have any alternate way

[sunny_talwar]

May be if you can share a sample, I might be able to look into it. Difficult to guide without knowing what all you have

[ajaysingh285]

These are my two expressions which gives the sum of $ value column. How can we do the Quarter percentage in this

=(sum({< [Month End]={'$(vVariable)'},nDateMonth={'<$(vStartMonth)'}>} [Budget])  /  $(vDividend)) +

(sum({< [Month End]={'$(vVariable)'},nDateMonth={'>=$(vStartMonth)'}>} [Budget])  /  $(vDividend))

[sunny_talwar]

Don't know.... ... expressions alone don't really help understand what else might have... image or sample might help

[ajaysingh285]

In this i need % values Quarterly with the help of using that expression.

for ex:-

Q1$ values / (Q1 $ value+Q2 $ value+Q3 $ value+Q4 $ value)

like wise for Q2,Q3,Q4 as well with help of expression.

Quarter is dimension here and in $ values is used as expression .

[sunny_talwar · Accepted solution]

And this isn't working?

=((sum({< [Month End]={'$(vVariable)'},nDateMonth={'<$(vStartMonth)'}>} [Budget])  /  $(vDividend)) +

(sum({< [Month End]={'$(vVariable)'},nDateMonth={'>=$(vStartMonth)'}>} [Budget])  /  $(vDividend)))/

((sum(TOTAL {< [Month End]={'$(vVariable)'},nDateMonth={'<$(vStartMonth)'}>} [Budget])  /  $(vDividend)) +

(sum(TOTAL {< [Month End]={'$(vVariable)'},nDateMonth={'>=$(vStartMonth)'}>} [Budget])  /  $(vDividend)))