how to calculate

[#1]

Hi,

   Everyone, I got a question. the script is as follows:

t:

LOAD * INLINE [

     Level2, Sales

    B, 3

    A, 7

    B, 4

    A, 2

];

LOAD * INLINE [

    Level1

    A

    B

    C

];

Now I have a question, I choose Level1='A', how to make the chart like bellow:

That means Level2 only appear the value where Level2 = Level1

So, how could I change the expression?

[tresesco]

Try:

sum({<Level2={"=Level2=Level1"}>}Sales)

[#3]

for further, if i choose Level1={'A','B'},then error is coming

[tresesco · Accepted solution]

Try:

sum({<Level2=P(Level1)>}Sales)

[Digvijay_Singh]

may be like this -

Sum({<Level1=,Level2={"=Level2=Level1"}>}Sales)