Sub Total Column and Place another column as shown below

[Ribeiro]

I need to bring the subtotal value of each dimension in the total store column. as set analysis below.

STORE:

sum({$<[EFETIVADA]={'1'},[CANCELADA]={'0'},[EVENDA]={'1'},[TIPOSAIDAENTRADA]={'S'}>}VALORTOTAL)

-
IF(sum({$<[EFETIVADA]={'1'},[CANCELADA]={'0'},[EVENDA]={'1'},[TIPOSAIDAENTRADA]={'S'}>}VALORTOTAL),
SUM(TOTALDEV))

STORE TOTAL?

[sunny_talwar]

What is your chart dimension in this chart? Also, make sure to list them in the order of when try appear in the chart

[Ribeiro]

I need the subtotal according to the image

LOJA, VENDAS, SUBTOTAL_VENDAS, TOTAL GERAL, DT,
A, 20, 30, 160, 15/01/2020
A, 10, 30, 160, 15/01/2020
B, 20, 70, 160, 18/01/2020
B, 40, 70, 160, 18/01/2020
B, 10, 70, 160, 18/01/2020
C, 50, 60, 160, 19/01/2020
C, 10, 60, 160, 19/01/2020

];

[Ribeiro]

To pass to expression below the dimension is the same of the attached qvw.

soma ({$ <[EFETIVADA] = {'1'}, [CANCELADA] = {'0'}, [EVENDA] = {'1'}, [TIPOSAIDAENTRADA] = {'S'}>} VALORTOTAL)

-
SE (soma ({$ <[EFETIVADA] = {'1'}, [CANCELADA] = {'0'}, [EVENDA] = {'1'}, [TIPOSAIDAENTRADA] = {'S'}>} VALORTOTAL ),
SUM (TOTALDEV))

[sunny_talwar · Accepted solution]

For your sample below would work

Sum(Total<DT> VENDAS)

 

[Ribeiro]

Tranks Sanny😁