-
1. Re: Prevent Fixed LOD function from being altered by filters
Norbert MaijoorDec 7, 2016 8:23 AM (in response to Nadir Steinmetz)
-
ExampleFixedSales.twbx 1.1 MB
-
-
2. Re: Prevent Fixed LOD function from being altered by filters
Nadir Steinmetz Dec 7, 2016 8:42 AM (in response to Norbert Maijoor)Hi Norbert,
Thank you very much for your response.
However, I want to combine info, for example considering total sales of Segment 4, in GroupE in Region 4, what would be market share of each company. Therefore I put more than one dimensions in my Fixed Sales calculated camp.
Is there any way to do this?
Regards
Nadir
-
3. Re: Prevent Fixed LOD function from being altered by filters
Shinichiro MurakamiDec 7, 2016 9:41 AM (in response to Nadir Steinmetz)
1 of 1 people found this helpfulNadir,
Here is my approach.
Because your data includes Null, Filtering Company is resulted in losing the frame work.
Instead, duplicate the data source and link only with fields in the table. But exclude "Company"
If you data has 0 on all the combination of the table, you initial approach should work.
Thanks,
Shin
-
5. Re: Prevent Fixed LOD function from being altered by filters
Nadir Steinmetz Dec 13, 2016 5:04 AM (in response to Shinichiro Murakami)Thank a lot Shinichiro!!
I believe this solves my issue.
Best regards,
Nadir
-
6. Re: Prevent Fixed LOD function from being altered by filters
Shinichiro MurakamiDec 13, 2016 5:25 AM (in response to Nadir Steinmetz)
You are welcome.
Could you mark my answer as correct.
Thank,s
Shin