-
1. Re: Filter (All) data and show "Furniture" data.
saurabh.c.0 Feb 27, 2018 12:18 AM (in response to Minnu Meena)1 of 1 people found this helpfulUse sets
-
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.
-
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
-
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?
-
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 -
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
-
-
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
-
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.
-
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
-
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.
-
11. Re: Filter (All) data and show "Furniture" data.
Arvind Salunkhe Feb 27, 2018 2:49 AM (in response to Minnu Meena) -
12. Re: Filter (All) data and show "Furniture" data.
saurabh.c.0 Feb 27, 2018 2:07 AM (in response to Minnu Meena)1 of 1 people found this helpfulCreate 2 different sheets and 2 different calc fields . Then the same parameter can filter different datasources using different logics
-
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.