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