Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Quarterly Trend

Hi All,

 

In the below Dataset, i wish to show the closing amount for every quarter end in a graph.

 

For example, in graph i wish to present the sales of Mar 1515, Jun16000 ( not the cummulative sales figures).

Please help me on the same.

 Regards,

Varun

Need Help

8 Replies

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    7 years ago

    Anonymous

     

    I suggest you to use date instead of month name

     

    Then creating a new measure as the screenshot below. Then you can get the result.

    Hope this is helpful.

     

    Thanks and BR

    Ryan

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thanx Rayan.

       

      I'll try this and reach you incase of any help

      • ryan_mayu's avatar
        ryan_mayu
        Super User
        7 years ago

        Anonymous 

         

        No problem. Please feel free to contact me if you have any questions.

         

        Please kinldy mark my previous answer as a solution if it totally solved your problem. Appreciate you can give me a Kudo as well.

         

        Thanks and BR

        Ryan

  • AlB's avatar
    AlB
    Community Champion
    7 years ago

    Hi Anonymous

    Is the amountyou're referring to the amount for the last day of the quarter? Or the cumulative for the last month in the quarter?

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi, Its not the Cummulative amount, it is the amount of the last Day of the quarter

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        I Mean, the amount is the value of the sales as on end of the last month of the quarter