Create This Calc, Drag to Filter and SET TRUE
Your Store field in your data=Select(Mall Store) Parameter
Otherwise you can do this:
IF Your Store field in your data=Select(Mall Store) Parameter THEN Net Sales Current Year ENd
In Your Data Code Create This Calc:
IF Store Type+"Mall" Then 1 Else 2 End
Then Compare this in your Previous Calc with Parameter
Pl create a .twbx using your data as You have one column without Header, so Pl Create something and I will help, if you get stuck.
Mr Deepak, what's PI ?
Pl means Please
As per the data you've two different fields (Mall and Store Name) and you've created an integer parameter (Select ( Mall / Store )) having values (1=Mall and 2=Store). I'm assuming that you'd like to see the Net Sales Value based on selection of parameter. Like if we select not null values from Mall dimension then total net sales which is 21,279. In case of Store Name there is one null values and I think you'd like to exclude in your total net sales so result should be 21,245. Correct me if I'm wrong.
Here is my approach,
Write a case statement to call the dimensions using parameter. It'll refer respective dimension while selection.
[Mall / Store Dimension]:
CASE [Select ( Mall / Store )]
WHEN 1 THEN [Mall]
WHEN 2 THEN [Store Name]
Now using the above calculated field we'll get the Net Sales like this. NOT ISNULL() function will exclude the null values from the list of your dimensions.
IF NOT ISNULL([Mall / Store Dimension]) THEN [Net Sales Current Year] END
See the output,
Workbook attached for your reference. Let us know if this help.
Book1-Revised.twbx 31.3 KB