Different Filter for each column in SAC

[Domae]

Hey guys,

I am new to SAC and currently I am trying to build a simple report. I want to display a simple table which shows the revenue for the products. But I have a requirement to display the revenue measure for two different time periods to compare it afterwards.

I tried to set a filter on the date and add the two periods, but I always get only one column which displays the revenue.

I want something like this:

And then I would add a third column with a calculated measure, where I compare both periods.

Is this possible in SAC?

Best regards

Dominik

[Jay_Gandhi · Accepted solution]

Hi Dominik,

There would be a few different ways to accomplish this.

One of them would be via dynamic time filters and calculated measures.

Here are a few blog posts/help which may help:

Creating Dynamic Version over Version and Time Reporting with SAP Analytics Cloud (Column over Colum...

Get Time Back on Your Side with Dynamic Time Filters | SAP Blogs

Video: Apply Dynamic Time Range Filters (sap.com)

Jay

[Domae · Accepted solution]

Hey Jay,

thanks sooo much! That was exactly, what I was searching for! I followed your first blog and it served me pretty well!!

Best regards

Dominik