Forum Discussion

PowerBINewbie's avatar
PowerBINewbie
New Member
9 years ago

Accumulated stockvalue

Hi,

 

I have summarized a stockvalue for what it was last time the report was refreshed. Now i want to enhance it so i can see the trend over time. I have a log of the movements in the the stock. Where every line includs current value per part no, part no. and a datestamp. Now i whant to summarize this so i can see what the total value of the stock was every day for instance the last two months.

 

I have tried a couple of solutions but the problems that all my solutions summarzies all previous instance for every part no. I only whant to summarize the latest instances for every part no. per day, where the instance is older or on the same day. For a certain period, ex, 2 months.

 

 

Any help would be greatly appreciated.

6 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi PowerBINewbie,

       

      According to your description, I'd like to suggest you use line chart to achieve your requirement.


      Drag Datum column to "Axis" field, Varde to "Value" field. instance to "Legend" field.

       

      Regards,

      Xiaoxin Sheng

       

       

      • PowerBINewbie's avatar
        PowerBINewbie
        New Member
        9 years ago

        Thanks for your answer Xiaoxin Sheng.

         

        Unfortunately this doesnt work because that each part.no. has more than one instance and all instances has a value. So this means that it will sum the value of all instances per part.no up to each date. So the value of the stock is 100times greater than the real value.

         

        Regards,

        PowerBINewbie