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?
