cell value format

[Zalabya83]

Hello,

i'm using the below table to track monthly sales, i inserted a slicer with the data in order to auto filter based on my selection, in the lookup column (index formula & slicer used) i cant or don't know how to get (Quantity-Amount or %) with its cell format, example: if i want to select % it should get me the result with % and if i choose amount it should get me the data with EGP and so on, what i managed is that i can retrieve based on my selection what i want but not with its cell format.
any advise on that.

Year	Category	Target	Quantity	Amount	%	X	Y	Lookup	Max	Min
2019	4G Sim	1492774	1235197	EGP 6,175,980	83%			0.8275
	ACCESSORIES	120314	84915	EGP 13,173,245	71%			0.7058
	Cash in	412249	309255	EGP 0	75%			0.7502
	Cash out	333610	231004	EGP 0	69%			0.6924
	Corp	29570	67406	EGP 670,220	228%			2.2796
	DEVICES EGP	EGP 319,286,071	190784	EGP 272,468,802	85%			0.8534
	Eagle	77602	104170	EGP 1,046,621	134%			1.3424
	fox	352480	320977	EGP 7,681,550	91%			0.9106
	Hybrid	1348261	967885	EGP 38,258,315	72%			0.7179
	LINK	10941	57918	EGP 0	529%			5.2935	5.293515087
	MI	458792	227504	EGP 0	50%			0.4959		0.49587627
	POST MBB	32082	74604	EGP 9,645,362	233%			2.3254
	PRE MBB	30168	77006	EGP 896,510	255%			2.5526
	Wallets	389785	332897	EGP 0	85%			0.8541

<colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>