Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I am Having A table like below
If i select any filter the valves are changing like below
Please any one can help me how to resolve it.
Thank You In advance
Krishna.G
So the table should not change even if any filter selected?
If you select any filter The valve of that filter won't change.
What is the expression you are using?
Using the following Expression
Round((Count({<"Commodity Group"={'HDD - Hard Disk Drive','SSD - Solid State Drive','Power Supply'}>} actn_part_srl_nr2)/count(total<[Commodity Group]>BU))*1000000)
+ Round((Count({<"Commodity Group"={'Processor'}>}[ncnfrmc_cd1])/Count(total<[Commodity Group]>BU))*1000000)
+ Round((Count({<"Commodity Group"={'Memory'}>}[ncnfrmc_cd2])/
if(
[Commodity Group]='Memory',
Count({<[Commodity Group]={'Memory'},[Standard Supplier]={'Samsung','SK Hynix','Micron','Kingston'}>}BU),
Count(total<[Commodity Group]>BU))*1000000)
)
looks like the If condition is the problem here. It will change it based on the selections
can you try below
if(
only({1}[Commodity Group])='Memory',
Count({<[Commodity Group]={'Memory'},[Standard Supplier]={'Samsung','SK Hynix','Micron','Kingston'}>}BU),
Count(total<[Commodity Group]>BU))*1000000)
)
or try wrapping up the if statement or entire expression with aggr like below
sum(aggr(if(
[Commodity Group]='Memory',
Count({<[Commodity Group]={'Memory'},[Standard Supplier]={'Samsung','SK Hynix','Micron','Kingston'}>}BU),
Count(total<[Commodity Group]>BU))*1000000)
), Osv_category,Month))
Sorry its not working
This one also not working
Thanks for response
Provide sample app