Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please Edit you question, add a sample data set, the current output, the expected output,
The expression you are using, Currently we dont know anything about what you are doing.
Hi Gabbar,
Thanks for the reply. Please find the attached screenshot. Overall total value is not displaying correctly..
Total shows Wrong..
Expectation Totals need to be shown correct..
Expression Used in Pivot table :
if(Flag='Inventory',Num(sum({<Flag={'Inventory'},Month={"$(=Max(Month))"}>}[LY Actual])/vUnit,'#,##0'),
if(Flag='MAT Sales',
Num(if([Level 4 Description]='PH',
(sum(TOTAL <[Level 4 Description1],[Level 3 Description],[Level 6 Description1],[Level 5 Description1],[BG],[BU],[Business],[Business Model]>{$<[BG-C/MKT-C-MAT]={'World'},Flag={'MAT Sales'},Month={"$(=Max(Month))"},MonthL=>}aggr(sum({$<[BG-C/MKT-C-MAT]={'World'},Flag={'MAT Sales'},Month={"$(=Max(Month))"},MonthL=>}[LY Actual]),[Business Model],[Business],[BU],[BG],[BG-C/MKT-C-MAT],[Level 4 Description1],[Level 3 Description],[Level 5 Description1], [Level 6 Description1]))/vUnit),
//($(mktcformulalytoghsht1))
(sum(TOTAL<[BG],[BU],[Level 4 Description],[Business],[Business Model]>{$<[BG-C/MKT-C-MAT]={'BG-C','MKT-C'},Flag={'MAT Sales'},Month={"$(=Max(Month))"},MonthL=>}aggr(sum({$<[BG-C/MKT-C-MAT]={'BG-C','MKT-C'},Flag={'MAT Sales'},Month={"$(=Max(Month))"},MonthL=>}[LY Actual]),[BG-C/MKT-C-MAT],[Business],[Business Model],[BG],[BU],[Level 4 Description]))/vUnit)
),'#,##0'),
if(Flag='Inv/Sales',Num(sum({<FlagSource={'Inventory'},Month={"$(=Max(Month))"}>}[LY Actual])/vUnit
/(if([Level 4 Description]='PH',
(sum(TOTAL <[Level 4 Description1],[Level 3 Description],[Level 6 Description1],[Level 5 Description1],[BG],[BU],[Business],[Business Model]>{$<[BG-C/MKT-C-MAT]={'World'},FlagSource={'MAT Sales'},Month={"$(=Max(Month))"},MonthL=>}aggr(sum({$<[BG-C/MKT-C-MAT]={'World'},FlagSource={'MAT Sales'},Month={"$(=Max(Month))"},MonthL=>}[LY Actual]),[Business Model],[Business],[BU],[BG],[BG-C/MKT-C-MAT],[Level 4 Description1],[Level 3 Description],[Level 5 Description1], [Level 6 Description1]))/vUnit),
(sum(TOTAL<[BG],[BU],[Level 4 Description],[Business],[Business Model]>{$<[BG-C/MKT-C-MAT]={'BG-C','MKT-C'},FlagSource={'MAT Sales'},Month={"$(=Max(Month))"},MonthL=>}aggr(sum({$<[BG-C/MKT-C-MAT]={'BG-C','MKT-C'},FlagSource={'MAT Sales'},Month={"$(=Max(Month))"},MonthL=>}[LY Actual]),[BG-C/MKT-C-MAT],[Business],[Business Model],[BG],[BU],[Level 4 Description]))/vUnit)
)),'##.#%')
)))
As I can Notice there are three dimension, The total that is being shown is the Value which will correspond to dimension number.
Try aggregating the value on the finest Dimension, it should work.