Has anyone been successful in obtaining a YTD | Most Recent Month | 2n Most Recent Month | Month | ..Month @ Beginning.
Example: In Excel the chart looks like this: Columns p-? go to the beginning of the year. With the most recent month besides the YTD column.
Unfortunately the totals in Sisense are completely incorrect for the month. YTD totals in Sisense are spot on but when I attempt to add the MONTH, the totals get wacky.
The closest I can get in Sisense Pivot looks like this:
is this possible?
Please sign in to leave a comment.