Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: Running total in mdx

  1. #1
    Join Date
    Jan 2018
    Posts
    13

    Default Running total in mdx

    I want to calculate running total of my measures.I used SUM(YTD([Date].[YEAR].CurrentMember), [Measures].[ProfileCreated]) It gives a right result within same year but when a new year starts its starts with 0.I want to calculate previous year data too. How can I do?
    Dimension: Date-> default->Year->Month->Day
    Attached Images Attached Images   

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2017 Pentaho Corporation. All Rights Reserved.