Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
What is your chart dimension in this chart? Also, make sure to list them in the order of when try appear in the chart
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
];
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))
For your sample below would work
Sum(Total<DT> VENDAS)
Tranks Sanny😁