How to get the score for overall month

[rkpatelqlikview]

Hi Experts,

I'm facing the issue with this data.

I do have columns Date, StoreID and that performance. Here i need to give the score for Each StoreID and categry for month wise like below screen shot.

In dashboard if i click on StoreID it should give the entire score, if i select the month it should give that particular month score.

Here is the formula i used in the back end with resident but its not giving the entire month calulation score.

Score=  (Rangesum(P1,P2,P3,P4) /Sum(Sales)) * 1000

categry=  If((Rangesum(P1,P2,P3,P4) /Sum(Sales)) * 1000 <=20, 'Green',

                     IF( (Rangesum(P1,P2,P3,P4) /Sum(Sales)) * 1000 >20 and

                             (Rangesum(P1,P2,P3,P4) /Sum(Sales)) * 1000  <=50, 'Yellow', 'Red'))).

[bramkn]

you can do this in the front end with a pivot table

[rkpatelqlikview]

Thanks Bram, I have done in the Pivot table, here i need to assign the score to each StoreID and then need to show top StoreID's which is in Green and Bottom StorID's which Yellow and same Red as well in text object.

[rkpatelqlikview]

Is there any chance to do with the by "Group By" ?

[bramkn]

I am guessing what you need to do is add fields for the different calculations you want. these fields can be calculated seperately with group by clause.

edit: my community is acting strange and I don't see new posts when they do show up as new in inbox.

[rkpatelqlikview]

Exactly Bram, of course need to do calculations add some new fields to that calculation. .

I did with Group by but its not coming out put.

[bramkn]

Can you share your code? Would be easier to spot what is going wrong.

[rkpatelqlikview]

Sure Brem,

PFA the Qvw.

[ravikumar_iyana]

Hi Kumar,

You can try Straight Table.

Thanks,

Ravi

[rkpatelqlikview]

Thanks Ravi, I have done in the Pivot table, here i need to assign the score to each StoreID and then need to show top StoreID's which is in Green and Bottom StorID's which Yellow and same Red as well in text object.

Re: How to get the sum of the transaction for overall month