Forum Discussion
tabular report
Anonymous , Not very clear, if take proudct category and subcategory in visual and they are filtered bu a slicer. You will get only selected values in visual ?
Sorry for that Matey, i will try to explain as clear as i can.
i have one table with 20 columns, 10 columns in a one slicer and rest of them are in other slicer.
user can select any value from these two slicers. i need to filter the main table based on selected column and then show it in the matrix report with both slicer selected value as row shown in my screen shot.
Let me explain what i have tried, i have create two sql views for two slicers, and merge these two views as one view and use that view column in matrix rows. Define the relationship in these 3 views in model, but it does not work as expected if i select one slicer value it work but both does not work .Hope i have explained it in a better way now. please do help me i am stuck here.
Thanks in advance,
Lilima.