Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
How can I filter specific data?
I want to delete or want to show the data excluding ("All") in the graph.
I have tried to set the range min/max but it didnt work.
I want the graph to show the data starting from -500 and assending order.
can you please help me out eith this.
Thank you,
Sachin
Exclude dimension value in your SetAnalysis
((Sum({$<[Year]={2017} , [CustomerName]-={'All'}>}[Gross Margin Actual Year]))
- (Sum({$<[Year]={"2016"},, [CustomerName]-={'All'}>}[Gross Margin Actual Year])))
Set Analysis: syntaxes, examples
Hi,
can you add more details ? the dimension, the expression.. the qvf file ?
Hello,
I am sorry, cannot add qvf file.
The dimensions are Customer name and Gross margin
And the expression in gross margin is
((Sum({$<[Year]={"2017"}>}[Gross Margin Actual Year])) - (Sum({$<[Year]={"2016"}>}[Gross Margin Actual Year])))
Regards,
Sachin
Try to uncheck "include null values" on the dimension parameters
It Is unchecked.
so you have a value called "All" in your dimension field ?
Yes & I want to exclude only that value in the graph and show the remaininng values.
so here it is:
((Sum({$<[Year]={"2017"},Customer-={'All'}>}[Gross Margin Actual Year])) - (Sum({$<[Year]={"2016"},Customer-={'All'}>}[Gross Margin Actual Year])))
No this does not works. It still gives me the value "All"
Exclude dimension value in your SetAnalysis
((Sum({$<[Year]={2017} , [CustomerName]-={'All'}>}[Gross Margin Actual Year]))
- (Sum({$<[Year]={"2016"},, [CustomerName]-={'All'}>}[Gross Margin Actual Year])))
Set Analysis: syntaxes, examples