Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Sum in quarter

Hi everybody! It's my first time writing here :-) I would really appreciate your help to solve this issue. I have a table which contains these values:   DAYS   | Count of number of runs | Cumu...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

parry2k : shall I add something else?

 

parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

Anonymous  would you mind sharing sample data in excel and get back to you, you are using running total and thats' why q2 includes q1 data and so forth so on.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Maybe I can do the trick by subtracting the value from the previous quarter in the formula?


    Unluckily it is quite difficult for me to share the Excel, since it contains a lot of data, that I cannot share :-(

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    7 years ago

    Anonymous trying to see what we can do here, may be just get sample data of few quarters with minimum column, do you think that is possible?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi parry2k,

     

    Here's an Excel as an example. Each tab is obtained from different queries. I have added a relationship between the list-days and all the other days in the example.

     

    Excel example

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    >.< Can someone please help me? :-(

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    7 years ago

    Anonymous i just looked at your sample file but few things are not clear to me. I'm available to help, just send me private message to set up a time to connect so that we can work on it together, i'm available in pacific time zone. Thanks