Hi hi pratik gandhi,
Could you please share your workbook with us?
In the mean time, you could try the two followings:
- Turn on Analysis->Table Layout->Show Empty Columns. This will make Tableau fill in the crosstab, but in most cases you wouldn't be able to get Tableau to show anything in those cells. The kind of padding done by Show Empty Columns and Show Empty Rows is mostly not addressable by table calculations, not fillable by Field->Pane tab->Special Values->Text, etc., it's just for visual display.
- Use a custom query or custom SQL to pad out your data to include those missing values. This will create extra records, so you'd have to be careful using a calculated field instead of just SUM([Number of Records]), but will work.
Lénaïc RIÉDINGER, Global Community Engineer Tableau
If you see a Helpful or Correct response, please mark it thanks to the buttons below the targeted post!