So today we are going to show you how you can easily exclude members from your XLCubed reports. Here we have a simple grid which shows lowest level descendants of Promotions on rows and Geography on columns.
We would like to rank this report and also exclude the Promotion No Discount which is not really adding any value to the report.
So let’s edit the Promotions hierarchy and set up the exclusion of the No Discount Promotion.
Click the Advanced tab and then the Add Member List icon:
You will see a window as below:
Now click the drop-down on the right-hand side member list and select Edit. This will allow us to edit the member set:
We are going to exclude No Discount so select it and drag it across.
Next we need to choose one of the following operations to perform on our two member lists:
Add – left and right sides combined
Common – must exist on left and right side
Subtract – left side minus right side
We will select the subtract operator and click OK. We will also click this icon to rank the result:
Let’s rank these Promotions based on the current measure, Reseller Sales Amount:
The Promotions hierarchy has now been edited to exclude No Discount and then ranked.
Our report now looks like this:
As you can see the report now excludes No Discount row and has been ranked to show the top 10 Promotions across All Geographies.