I hope the below Raw script will help you.
You can fine tune the attached application based on your requirements.
LOAD now() as Reload_Time
,RowNo() as Rno
,if(mod(RowNo(),12)=0,12,mod(RowNo(),12)) as Month
,round(Rand()*100,1.00,2) as Revenue
,'CAT '& num(mod(RowNo(),3)+1) as Category
LOAD * INLINE [
CAT 1, Revenue*100
CAT 2, Reveue*200
CAT 3, Revenu*300
Dynamic QV Formula.qvw 158.2 K
Thanks for the example.
In your example , your master table already have 3 categories Cat1,Cat2 and Cat3
My problem is that my fact table does not have category 3 but have a amount which i can use if i have Cat3.
So i need to create a value in the existing Category and display it in the list box and when user select Cat3 perform calculation.