Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Sir/Madam
I try to present Products by Country but not sure all Products appear in each country, can someone kindly help to solve my problem ?..
The correct answer should be Country A and B only show products with Prefix T and B respectively.
Thank you
Tracy
Dear John
Thank you so much for your kind effort and advices.
I totally agree that it is impossible to exclude those unwanted products in Trellis chart. I also find it difficult to follow your advice as it is too advance for me to understand such as concatenating country ........
Anyway thank you again
Tracy
Dear Jyothish
All the time, I am using Trellis chart but unable to exclude unwanted Products by Country.
Regards
Tracy
Hi Tracy,
In that case you try creating a separate data set excluding those product and use the new data set for building trellis charts . Just a thought, it might increse the app size if you are dealing with huge data.
Something like this:
A:
Load
Product,
Country
from <>
B:
Load
Product as NewProduct
Country
resident A
where Product <> 'ABC';
Then use New product in the charts.
Br,
KC
Dear Jyothish KC
This is not what I want as I will have to write many scripts for all products.
Regard
Tracy
Your requirement is not possible.