Yes, you could use presentation variable for this.
What error do you get? Please description.
Or you can use for example column selector when you choose between male/female colummn.
It depends how you hold data for male/female? Do you have two columns male and female or in one column do you have value male and female?
I have tried using presentation variable
but it is showing error
What error is it showing? What have you done EXACTLY in terms of configuration? How is your data stored? What's the data relationship between male and clothes? Just two levels of a dimensional hierarchy or attributes of the same logical dimension table?
Your requirement is extremely common so instead of looking for an alternative solution it's better to search for the reason that the solution which works for everyone else isn't working for you.
But it seems i am not properly describing the issue
let there are 2 columns in a table
gender clothes_type cloth type unit price
now the requirement is like i have to create 2 prompts 1.gender
when i click gender as male it should show only the 3 values for men clothes type in the prompt drop down.
and i can also be able to chose from those clothes type.
the output will be unit_price for clothes_type
So as I assumed in my reply no need for any variables at all. Your first table just becomes the dimension with "Gender" being the one level above "Clothes_Type" and everything will just work peachy with standard functionality, no coding, no variables.
ohh you mean i have to create a hierarchy???
then it will work fine??
lemme try it