How to neglect two months data based on condition

[abc_18]

In excel i have date data from Oct-16 to Jun-17.

In Dashboard UI part I just want to show data from Dec-16 to Jun-17, how to achieve this.

[awhitfield]

Either limit the load so the values aren't imported OR use set analysis so they are not displayed.

Andy

[mangalsk]

You need to exclude in script using where exists or not exists as per data available

[shiveshsingh]

You can use set analyis for excluding the months

[rahulpawarb · Accepted solution]

Hello Shikha,

Below are sample solutions (please make necessary changes, if needed):

1. Script level

Where Date >= '12-01-2016'

2. KPI level

Sum({<Date={">= $(=Date#('12-01-2017', 'MM-DD-YYYY')) "}>}SalesAmount)

Regards!

Rahul Pawar