13 Replies Latest reply on Feb 27, 2018 2:49 AM by Arvind Salunkhe

Filter (All) data and show "Furniture" data.

Minnu Meena Feb 26, 2018 11:59 PM

Hello All,

I have a dimension called Category. In the category i need to display only "Furniture".

If I select all then nothing should be display . If i select "Furniture" then only furniture value should be displayed. How ca we achieve this?

Can anyone please help me.

Thanks,

Minnu.

1. Re: Filter (All) data and show "Furniture" data.

saurabh.c.0 Feb 27, 2018 12:18 AM (in response to Minnu Meena)

Use sets
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
2. Re: Filter (All) data and show "Furniture" data.

Minnu Meena Feb 27, 2018 12:25 AM (in response to saurabh.c.0)

I tried by using sets also but i couldn't solve it.
Like Show 0 Likes(0)

Actions
3. Re: Filter (All) data and show "Furniture" data.

saurabh.c.0 Feb 27, 2018 12:29 AM (in response to Minnu Meena)

You can also create a parameter and use it in calc field
Like Show 0 Likes(0)

Actions
4. Re: Filter (All) data and show "Furniture" data.

Minnu Meena Feb 27, 2018 12:32 AM (in response to saurabh.c.0)

Can you please help me how can i add parameter condition in calculation?
Like Show 0 Likes(0)

Actions
5. Re: Filter (All) data and show "Furniture" data.

saurabh.c.0 Feb 27, 2018 12:36 AM (in response to Minnu Meena)

1 of 1 people found this helpful
Like Show 1 Likes(1)

Actions
6. Re: Filter (All) data and show "Furniture" data.

Tolga Cömert Feb 27, 2018 12:41 AM (in response to Minnu Meena)
Hi,

Check this workbook, i edited it as i understand and i believe it will help you.

Color Code.twbx 1.1 MB

2 of 2 people found this helpful
Like Show 1 Likes(1)

Actions
7. Re: Filter (All) data and show "Furniture" data.

saurabh.c.0 Feb 27, 2018 12:47 AM (in response to Minnu Meena)

if [Category Parameter] = "Furniture" then {FIXED[Category Parameter]:sum(if ([Category] = "Furniture") then [Sales] END )}
elseif [Category Parameter] = "all" then NULL
END
Like Show 0 Likes(0)

Actions
8. Re: Filter (All) data and show "Furniture" data.

Minnu Meena Feb 27, 2018 1:03 AM (in response to saurabh.c.0)

Hi in my view i should not use parameter because i have connected to two different data sources. But both of them consist of same dimension field called "Category".
Category filter set to both the data sources as "All using related data source". So what ever i will select that action is going to perform for both the data sources.

But my task is in the 2nd data source when i select Furniture only furniture to be displayed. When i select All category then nothing to be display by using the same category field applied to 1st data source. So that is the reason i cannot create parameter. Only with the existing field category i need to display furniture in the second data source.
Like Show 0 Likes(0)

Actions
9. Re: Filter (All) data and show "Furniture" data.

saurabh.c.0 Feb 27, 2018 1:10 AM (in response to Minnu Meena)

Not necessary...You can remove the setting "All using related data source" and only apply filters via parameter to only 1 data source
Like Show 0 Likes(0)

Actions
10. Re: Filter (All) data and show "Furniture" data.

Minnu Meena Feb 27, 2018 1:19 AM (in response to saurabh.c.0)

I can do it but for my client category filter should apply both the data sources at a time. So with the category filter only i need to perform the actions respectively for both the sources.
Like Show 0 Likes(0)

Actions
11. Re: Filter (All) data and show "Furniture" data.

Arvind Salunkhe Feb 27, 2018 2:49 AM (in response to Minnu Meena)

Hi Minnu,

I have recreated your scenario

1. Create parameter to select Category
2. Create a Calculation for Sales :
IF [Select Category]="Furniture"
then SUM(IF [Category]="Furniture" then [Sales] else 0 end)
else 0
END

Please check the result in below viz
Like Show 0 Likes(0)

Actions
12. Re: Filter (All) data and show "Furniture" data.

saurabh.c.0 Feb 27, 2018 2:07 AM (in response to Minnu Meena)

Create 2 different sheets and 2 different calc fields . Then the same parameter can filter different datasources using different logics

1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
13. Re: Filter (All) data and show "Furniture" data.

Minnu Meena Feb 27, 2018 2:44 AM (in response to saurabh.c.0)

Thank you so much saurabh. I will try for sure.
Like Show 0 Likes(0)

Actions