How to display correct Total value when using crosstab?

[hadouku]

Hi everyone,

I'm currently using a Crosstab to display a revenue table, the data is filtered by a list of magazines and their corresponding no. of copies sold, total revenue and payment method used, as shown below.

The Total column should display the accumulative values for qty and revenue, that's added from each qty and revenue value of each payment type. Clearly the values from the Total column are incorrect. 

What would be the best method to calculate the total?

I noticed that Total column is displaying the last record with values greater than zero. For instance, Magazine 4 has zeros across the board except Paypayl Pro (that's been cut off from the image). Similarly, Magazine 5 has values across the board, and the last record with values are retrieved from Paypay Pro with the following values - 2 (Qty) and 190 (Revenue) which is replicated on the Total column.

I hope that makes sense.

Many thanks in advance.

Hadouku

[ajay_1311]

Please check, There might be measure value is mismatched calculation type. 

 

[siddhesh2525]

hey , can u tell me how to add group header and column header in cross tab...

 

thanking you!