I tried to solve it this way. I have attached the solution with a sample qvw application.
But I still have another problem, when I do a selection, I am not able to get the Total Sum bar.
Can anyone please help me.
Macro.qvw 158.2 K
Quick and dirty answer:
if(B_FACT_TYPE='$(vCurrValue)', sum(B_PRICE), if(len(GetCurrentSelections(B_FACT_TYPE))=0, sum(B_PRICE)))
Now, why DID you rename your FACT_TYPE field in your two tables? Why don't you want to connect them?
Also note that your approach only gives answers when no or a single A_FACT_TYPE are selected. If you select more than one, it fails.