Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm building various tables with various store location attributes. I'm now wanting to create a table that shows our unique store identifier ('PS #'), but ONLY for those stores that are scheduled for remodel.
So, in the Data Load editor, I created the following Flag:
IF ("Required?"='YES', 1, 0) as Remodel_Flag
The data loads fine, and I see the new 'Remodel_Flag' variable in my list of options, but where do I use this flag in the table so that just those PS#'s ('Remodel_Flag = 1') appear in the table?
Thanks for your help!
Make sure this is unchecked -> Show Null Values
1May be use it in your expressions if you wish to restrict your table to view only those rows where Remodel_Flag = 1
{<Remodel_Flag = {1}>}
HI Sunny, Hope you are having a good day.
This expression has an error:
[PS #]{<Remodel_Flag = {1}>}
May be try this:
Only({<Remodel_Flag = {1}>} [PS #])
Sunny, I get an 'invalid dimension' message:
I thought you were using it as an expression, try this:
If(Remodel_Flag = 1, [#PS])
It is suppressing the PS # field for records where Remodel_Flag = 0, but all the records are showing in the chart (whether Remodel_Flag = 0 or 1).
Thank You, Sunny...
Make sure this is unchecked -> Show Null Values
Thanks, Sunny - I can't even begin to tell you how much I've appreciated all your help...
Have a great day...
No problem Mike
I am glad I have been able to help you out with most of your queries.
Best,
Sunny