Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
This is my scenario. its a pivot table
country - USA UK CHI ESP CSB KOL
product
bulbs
capacitora
thermos
m120
c480p
therb90
basically all the products has to be shown but I need to limit the countries only to UK and USA. My problem is if I apply an filter on the countries .. certain product gets removed. I would like to keep the product as well and show that it is 0.
country - USA UK
product 0 0
bulbs 100 10
capacitora 0 10
thermos
m120
c480p
therb90
For your product dimension tick the Show All Values option.
Hi,
Go to presentation tab, and try this...
Hi,
Dimensions Tab -> Check Show All Values
Presentation Tab -> Uncheck Suppress Zero-Values ,Null Symbol -> 0 and Missing Symbol -> 0
no its not working. basically iam using a match condition to filter the countries while loading.. is their any other way to filter?
Hi,
Can you please share your QVW file please?
HTH-KC
Hi, Can you please share dummy data if possible.
Hi Please find the dummy data with qvw
Hi,
you can load all your data without limit in the script. you can restrict it in front end using set analysis
check the attachment. may be helps.