Pivote table display and (- )display at impossible calculations

[#1]

Saled YearMonth	Product	SalesOrder	Receiavable Amount	Service start Month
201004	QlikView9.0	SO1	100,000	*
201004	QlikView9.0	SO2	200,000	201004
201004	QlikView9.0	SO3	300,000	201005
201004	QlikView9.0	SO4	400,000	201006		SSM 201004 values coming forSYM 201004 (200000),201005(200000+300000),201006(200000+300000+400000) take these values as numerator and divide by whole amount i.e.1000000(sum for 201004 YM) and * values didnot have to consider for numerator calculation then we can convert it in % and get table as below
201005	QlikView9.0	SO5	100,000	201005
201005	QlikView9.0	SO6	200,000	*		Please refere following table for all calculations
201005	QlikView9.0	SO7	300,000	201007
201005	QlikView9.0	SO8	400,000	201006
201006	QlikView9.0	SO9	100,000	201006
201006	QlikView9.0	SO10	200,000	*
201006	QlikView9.0	SO11	300,000	201007
201007	QlikView9.0	SO12	100,000	*
201007	QlikView9.0	SO13	200,000	201007
201007	QlikView9.0	SO14	300,000	201007
	Hi Everybody,
	I am having a problem regarding a calculation. Please go through the data and the explanations given below and let me know how I can go forward with the calculation logic. Below given is the data which is used for the same.
	and display as specified below .I have data as shown in above table according to calculation formula as :
	Rate =Summation of all Receivable amount for peticular service start month related to saled year month value only/sum of whole amount for perticular saled year month .
	T'm able to get this calculation but I'm not able to get it in following fomat of display in PIVOT TABLE.
	Such that I want to put hypen(-) where values are not possible in these places .
	And if recevable amount is not possible for perticular month then carry above value till next value come or continue that value till end such as consider for Saled Year month of 201004 and service start month 201006 and 20107 value gets carried to next cell.
	Please help me in this situation main intation is to place - where values are not possible anybody can guide me please .
	I had tried presentatin null symbol option also…
	Product	Service start Month	Saled YearMonth	201004	201005	201006	201007
	QlikView9.0	201004		20%	.-	.-	.-
		201005		50%	10%	.-	.-
		201005		90%	50%	16.67%	.-
		201006		90%	80%	66.67%	83.33%

Please try to help me for same supress null value option changes values because of the value of * .

Please suggest me another option .

And to avoid total coloumn in pivote table what should I do ....

[#2]

Please anybody help me