PivotTable

[#1]

Hi Guyz,

please find the attached qvw file.

from the above pivot table i dont want to display 0-15 data of BMSS and  BOMSS& ZSTK of BSS.

Please help me in this context

Thank

REgards

Sampath botla

[amit_saini]

Hi Sampath,

Try this:

Data:

LOAD Catergory1,

     Catergory2,

     Exec_Date,

     Qty

FROM

DATA.xlsx

(ooxml, embedded labels, table is Sheet1)

where BSS<>ZSTK and BSS <> BOMSS;

if it works , apply same for BMSS.

Thanks,
AS

[felipe_dutra]

Hi,

I do not understand why you created an expression for each category 1, one could use the existing dimension.

See the example.

Felipe

[eduardo_sommer · Accepted solution]

Create a Pivot Table with 3 dimensions (Catergory1, Catergory2, Exec_Date), and the following expression:

    sum({$<Catergory1={'BMSS'},Catergory2={'0-15'}> + <Catergory1={'BSS'},Catergory1=-{'0-15'}>} Qty)

You can see this in the attached file

Eduardo

[dharmarasu]

Hi

Hope this helps...

find in attachments

Dharma