Forum Discussion
Solved
Divide Row value with Sub Total
Hello Expert, I need your help in getting the row subtotal value. I have given the example: I am not able to get the sub total value through meaure. beacuse i need to divide row value...
v-zhangti Thanks for your reply. I tried this already but I have few slicers of Year,Month, etc. when we select any value from slicer so measure values remain constant. I used ALLSELECTED as well but measure value is not changing as per slicer value selected.
Hi, Uzi2019
Please provide sample data and expected output. Sensitive information can be removed in advance.
Best Regards
v-zhangti Pasting smaple data and output below: (Measure should be working as per any value selected in Slicer by end user)
Expected Output:Region Category Product Spends Measure East A AR KU 100 0.166666667 East LE FU 200 200/600 East YUMM 300 300/600 East Total 600 600/600 East B GO CR 50 50/180 East GO HA 60 60/180 East GO PO 70 70/180 East Total 180 180/180 North A POPP 20 20/50 North S GOU 30 30/50 North Total 50 50/50 North B AARA 20 20/40 North N POT 20 20/40 North Total 40 20/20 Sample Data:
Regions Category Brand Quantity Year Month East A GO TE 29 2022 Jan East A AR KU 946 2022 Feb East A AR KU 962 2022 Mar East A LE FU 634 2022 Apr East A YUMM 677 2022 May East B AJI K -37 2022 Jun East B ITOS 1230 2022 Jul East B ITOS 1401 2022 Aug East B SER-D -35 2022 Sept East C GO NO 550 2022 Oct East C X FRI 2 2022 Nov East C YUMM -36 2022 Dec East C APURN -37 2022 Jan East D GO CR 635 2022 Feb East D GO HA 757 2022 Mar East D GO PO 2489 2022 Apr East D GO WA 1278 2022 May East D POPP -37 2022 Jun East D S GOU 42 2022 Jul East D S SIZ 2687 2022 Aug East D S WAF 2066 2022 Sept East D AARA -37 2022 Oct East D N POT -37 2022 Nov East D AL MA -37 2022 Dec East D YUMM -6 2023 Jan East D II D 204 2023 Feb East D II H 1368 2023 Mar East F GO MA 1993 2023 Apr East F CRAX -34 2023 May East F X COR 641 2023 Jun East F X CUR 152 2023 Jul East F AR KU 151 2023 Aug East F AR KU 215 2023 Sept East F AR PA -37 2023 Oct East F YUMM 220 2023 Nov East F LOW D 829 2023 Dec East G DH NA -37 2023 Jan East G AJI B -25 2023 Feb East G AJI M -34 2023 Mar East G AJI S -34 2023 Apr East G AJI T -37 2023 May East G ANO B -36 2023 Jun East G K FAR -37 2023 Jul East G MUKHA -37 2023 Aug East G SNAC -37 2023 Sept East G UJI N -37 2023 Oct East G DIRAM -37 2023 Nov East G DIRAM -36 2023 Dec