This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
P6ETLDB data source (shown in the attached screenshot) is pointing to which database?For example, If it is pointing to Oracle DB you need to look at Oracle DB docs for TRIM function that you can use w SQL.
You can use level based measure function to calculate sales total for quarter (Sum of Jan +Feb+Mar).In your case formula can be:SUM( <Revenue>, groupBy(<customer>, <quarter>) ) To calculate ratio use this formula:SUM( <Revenue> ) /SUM( <Revenue>, ...
MV is the only way to do rolling sum.You can find a work around to do something similar but design it without MV in the following video:https://www.youtube.com/watch?v=8Cpr9GnGR2s&t=1shttps://www.youtube.com/watch?v=wmpgfXQr9Ac