Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following pivot table (see attachment - "Tabella pivot.jpg") with two dimensions and an expression:
1) Dimensions: supplier and payment due date
2) Expression:
SUM({<[% Master Calendar Date Num]={">=$(=$(vInizioPC))<=$(=$(vFinePC))"}, Anno=,Mese=,Giorno=>}[# Imponibile Pagamento])
Did you try to drag the date column to the right top corner of the chart? This should let you pivot the Date dimension
May be you need this?
(
RangeSum(Above(TOTAL SUM({<[Master Calendar Date Calc]={">=$(=$(vInizioPC))<=$(=$(vFinePC))"}, Anno=,Mese=,Giorno=>}[# Importo Fattura Iva]),0,RowNo(TOTAL)))
-
RangeSum(Above(TOTAL SUM({<[Master Calendar Date Calc]={">=$(=$(vInizioPC))<=$(=$(vFinePC))"}, Anno=,Mese=,Giorno=>}[# Importo Fattura Pagamenti]),0,RowNo(TOTAL)))
)
Did you try to drag the date column to the right top corner of the chart? This should let you pivot the Date dimension
thank you very much. If you can give me a hand I would be grateful for another discussion.
I am unable to open your app for some reason.
I can download the qvw file, but I am unable to open it... the qvw window just hangs on me
ok try this.
thanks
May be this
No I'm talking about the other sheet; where in another post I asked for the cumulative difference of two columns.
The cumulative difference only works with one dimension if you expand the data in the table no.
The formula used is:
(
RangeSum(Above(SUM({<[Master Calendar Date Calc]={">=$(=$(vInizioPC))<=$(=$(vFinePC))"}, Anno=,Mese=,Giorno=>}[# Importo Fattura Iva]),0,RowNo()))
-
RangeSum(Above(SUM({<[Master Calendar Date Calc]={">=$(=$(vInizioPC))<=$(=$(vFinePC))"}, Anno=,Mese=,Giorno=>}[# Importo Fattura Pagamenti]),0,RowNo()))
)
Thanks
May be you need this?
(
RangeSum(Above(TOTAL SUM({<[Master Calendar Date Calc]={">=$(=$(vInizioPC))<=$(=$(vFinePC))"}, Anno=,Mese=,Giorno=>}[# Importo Fattura Iva]),0,RowNo(TOTAL)))
-
RangeSum(Above(TOTAL SUM({<[Master Calendar Date Calc]={">=$(=$(vInizioPC))<=$(=$(vFinePC))"}, Anno=,Mese=,Giorno=>}[# Importo Fattura Pagamenti]),0,RowNo(TOTAL)))
)