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.
<colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
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>