(Note to self. V9.3 workbook)
I took your sheet and added a table calc to grab the stuff that was displayed on the sheet and add it up (across, therefore for each customer.)
I threw it on TEXT so you can see the result. As you can see, you get the value in each cell across the row.
See Sheet 3. I took that same viz, took SUM(Sales) off text, and then added an INDEX filter just to grab the first value, since you only need 1.
Position those two sheets on a dashboard, and you'll have what you need.
The message you were getting is because MONTH(order date is DISCRETE, I think.
Sorry thats not the requirment,
As shown in my Screen shot ,Every thing in it is needed ..along with row Grand Total in same order mentioned on screenshot
I'm not sure what you actually need.
Your screen shot shows what you already had in the top-10 sheet. You'll get that if you take the table calc out of that sheet.
Further you said: "where i should get grand total too..even in different tab". I gave the grand total on a separate sheet.
So you put it together on a dashboard like in the attached. (See latest.)
Thank you very much..It Working:-)